Db2 Tools

Expand all | Collapse all

R/C Migrator does not support features Db2 already do

  • 1.  R/C Migrator does not support features Db2 already do

    Posted 02-19-2020 06:57 AM

    Hi.

    We are running a lot of Db2 object changes per day.

    Sometime we recognize that ANALYZE and / or SYNCHECK does not support new features Db2 already implemented.

    Out environment is Db2 V12R1M504 and we are on the way to V12R1M506.

    Does somebody have a list of features which will work or not?

    For the feature we miss, I'll do an ideation to call for votes.

    regards michael

    e.g.

    Create Table in DB with specified Bufferpool ends with RC=16 in AUTOMAP results in:

    RM00258I Automap process has been invoked: 20.0
    RCM00043: SQL errors found in import dataset:

    CREATE TABLE M526008.V9VATMIG ( WL_RECORD_ID VARCHAR ( 50 ) NOT NULL ,
    WL_RECORD_XML XML , WL_ASSOCIATION_XML XML , EINSTELL_ZP TIMESTAMP ( 6
    ) WITHOUT TIME ZONE NOT NULL WITH DEFAULT , VERAEND_ZEITPUNKT TIMESTAMP
    ( 6 ) WITHOUT TIME ZONE , PA_COMP_AKTION_ID DECIMAL ( 11 ) ,
    WL_RECORD_CSV_DJ VARCHAR ( 10000 ) , WL_EUCON_REL_MM CHAR ( 1 ) ,
    PRIMARY KEY ( WL_RECORD_ID ) ) IN DATABASE DVORGA1 AUDIT NONE
    #BUFFERPOOL# BP32K

    ************************************************************************
    DDL00002: Invalid token BUFFERPOOL. Valid tokens are:
    IN EDITPROC VALIDPROC AUDIT OBID
    DATA RESTRICT CCSID NOT VOLATILE
    PARTITION APPEND KEY LABEL NO KEY LABEL
    ************************************************************************



    ------------------------------
    [DBA and SYSPROG]
    [LVM Versicherung]
    [Germany]
    ------------------------------


  • 2.  RE: R/C Migrator does not support features Db2 already do

    Posted 03-04-2020 04:10 PM
    Greetings Michael,
    This post is clone of this (hyperlink) idea which is already responded. With this reason, we request to have a watch on the idea instead of this discussion. Please let us know if it is not okay with you.

    Best Regards,
    Srinivas Adupa
    Product Owner

    ------------------------------
    Product Marketing Engineer
    Broadcom
    [City]
    ------------------------------



  • 3.  RE: R/C Migrator does not support features Db2 already do

    Posted 03-05-2020 02:37 AM

    Good Morning Srinivas.

    Many thx for your reply.

    It's very kind that you mentioned the idea already, so all who read the post here can follow the idea also.

    And of course, it's absolutely ok for us to follow the idea, because the work is done there.

    regards michael



    ------------------------------
    [DBA and SYSPROG]
    [LVM Versicherung]
    [Germany]
    ------------------------------