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]
------------------------------