Preparing your Db2 for z/OS database for IBM Content Navigator

When you upgrade to IBM Content Navigator, you must update your IBM Content Navigator database to support additional features. However, you must take additional steps to prepare your Db2 for z/OS database for IBM Content Navigator

About this task

To prepare your database, you must run a job that alters the configuration table to:

• Increase attribute fields to 100M
• Use inline length to improve database performance

After you run the job, the database administrator must run the Db2 REORG utility.

To prepare your Db2 for z/OS database:

1. Log on to the server where Db2 Connect is located.
2. Connect to the database instance where your IBM Content Navigator database is running as a user with administrative authority over the IBM Content Navigator database.
3. Submit the following job:

     //ICNUPDAT JOB (XXXX),'ICN DB UPDATES',
   //             MSGLEVEL=(1,1),MSGCLASS=?MSGCLASS?,NOTIFY=&SYSUID 
   //JOBLIB    DD DISP=SHR,DSN=?DSN?.SDSNLOAD 
   //********************************************************************* 
   //* Licensed Materials - Property of IBM 
   //* 5724-U69 
   //* Copyright IBM Corp. 2014 All Rights Reserved. 
   //* US Government Users Restricted Rights - 
   //* Use, duplication or disclosure restricted by GSA ADP Schedule 
   //* Contract with IBM Corp. 
   //********************************************************************* 
   //* 
   //* SAMPLE JOB STREAM TO ALTER/UPDATE THE IBM Content Navigator V3.0 
   //* DATABASE. 
   //* 
   //* 
   //*   Job steps: 
   //* 
   //*   CM8403SK - Alter CONFIGURATION table 
   //* 
   //* 
   //* 1. CUSTOMIZE THE FOLLOWING FIELDS: 
   //* 
   //* 
   //*   @ECMClient_SCHEMA@ 
   //*             - ID OF CREATOR DEFINING THE DB2 OBJECTS 
   //* 
   //*   ?DB2RUN? 
   //*             - FULLY-QUALIFIED NAME OF DB2 RUNTIME 
   //*               LIBRARY OF DSNTIAD 
   //* 
   //*   ?DB2SYS? 
   //*             - DB2 SUBSYSTEM 
   //* 
   //*   ?DSN? 
   //*             - HIGH-LEVEL QUALIFIER OF DB2 SYSTEM LIBRARY 
   //* 
   //*   ?MSGCLASS? 
   //*             - JOB OUTPUT MESSAGE CLASS 
   //* 
   //*   ?SQLID? 
   //*             - SQLID 
   //* 
   //*   ?TIADPLAN? 
   //*             - DB2 PLAN FOR DSNTIAD 
   //* 
   //* 
   //* CM8403SK 
   //*   This step will perform the following changes: 
   //*    - Alter Cofiguration table column ATTRIBUTES 
   //* 
   //* 
   //CM8403SK  EXEC PGM=IKJEFT01,DYNAMNBR=20,REGION=1024K 
   //SYSTSPRT  DD SYSOUT=* 
   //SYSPRINT  DD SYSOUT=* 
   //SYSUDUMP  DD SYSOUT=* 
   //SYSTSIN   DD *  
    DSN SYSTEM(?DB2SYS?)  
    RUN  PROGRAM(DSNTIAD) PLAN(?TIADPLAN?) -       
   			LIB('?DB2RUN?') 
   //SYSIN     DD *    
   
   	SET CURRENT SQLID = '?SQLID?';    
   
   	ALTER TABLE @ECMClient_SCHEMA@.CONFIGURATION     
   		ALTER COLUMN ATTRIBUTES SET DATA TYPE DBCLOB(100M);    
   
   	ALTER TABLE @ECMClient_SCHEMA@.CONFIGURATION     
   		ALTER COLUMN ATTRIBUTES SET INLINE LENGTH 16206;     
   
   
   	COMMIT   
   	;  
   
   /*

What to do next

Ensure that your database administrator runs the Db2 REORG utility on the IBM Content Navigator database before you run the database upgrade script that is created by the IBM Content Navigator administration tool.