Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

-SETC (SET CURRENT APPLICATION COMPATIBILITY statement)

The -SETC command sets the application compatibility level. The following sections of the worklist might include -SETC commands for a table space, table, or synonym create:

  • ALIAS SECTION
  • CREATE MQTS
  • CREATE VIEW NOT DEPENDENT ON MQT SECTION
  • CREATE TABLESPACE SECTION
  • TABLE SECTION
  • UNATTACHED SYNONYMS SECTION

The -SETC command is applicable in IBM Db2 V12 or later subsystems.

The worklist omits -SETC if migrating objects from a subsystem with a lower application compatibility level (V12R1M503) to a subsystem with a higher compatibility level (V12R1504). On the receiving subsystem, use an installation module that specifies the APPLCOVR=Y option.

Example of the -SETC command

***********************************************************************
-SETC 000350 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'        
-SETS 000400 SET CURRENT SQLID = 'J1OSS9A'                               
-SQL  000450 CREATE  TABLESPACE BMCSEC3 IN DQACM121                     
                    USING STOGROUP SYSDEFLT                             
                    PRIQTY     -1                                       
                    SECQTY     -1                                       
                    PCTFREE    99   FOR UPDATE -1                       
                    BUFFERPOOL BP0                                      
                    CLOSE      NO                                       
                    SEGSIZE    4                                        
                                                                       
-SETS 000500 SET CURRENT SQLID = USER                                   
-SETC 000550 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'        
-SYNC 000600 END OF CREATE TABLESPACE SECTION                           
***********************************************************************
-SETC 000650 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'        
-SQL  000700 CREATE TABLE DQACM121.TB_BMCSEC3                           
 (                                                                      
  COL1                                                                  
     CHAR(6) NOT NULL WITH DEFAULT IMPLICITLY HIDDEN                    
 )                                                                      
                    CCSID EBCDIC                                        
  IN DQACM121.BMCSEC3                                                   
                                                                       
-SETC 000750 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'        
-SYNC 000800 END OF TABLE SECTION                                       
***********************************************************************


Related topics

Worklist-commands

ALUIN-keywords

ALTER-and-Change-Manager-installation-options


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*