Sample DSNJU003 control statements

Use the sample control statements as models for developing your own DSNJU003 control statements.

Example 1: Adding a new archive log data set

The following control statement specifies that the DSNJU003 utility is to add the data set DSNREPAL.A0001187 to the BSDS. The volume serial number for the data set is DSNV04, as indicated by the COPY1VOL option. The device type is SYSDA, and the data set is not to be cataloged. The RBA of the beginning of the archive log data set volume is 3A190000, and the end RBA is 3A1F0FFF.

//STEP5 EXEC PGM=DSNJU003,COND=EVEN            
//SYSUT1   DD DSN=DSNCAT.BSDS01,DISP=SHR       
//SYSUT2   DD DSN=DSNCAT.BSDS02,DISP=SHR       
//SYSPRINT DD SYSOUT=A                         
//SYSIN    DD *                                
NEWLOG DSNAME=DSNREPAL.A0001187,COPY1VOL=DSNV04,UNIT=SYSDA,
STARTRBA=3A190000,ENDRBA=3A1F0FFF,CATALOG=NO
/*

Example 2: Deleting a data set

The following control statement specifies that DSNJU003 is to delete data set DSNREPAL.A0001187 from the BSDS. The volume serial number for the data set is DSNV04, as indicated by the COPY1VOL option.

DELETE DSNAME=DSNREPAL.A0001187,COPY1VOL=DSNV04

Example 3: Creating a new conditional restart control record

The following statement specifies that DSNJU003 is to create a new conditional restart control record, which controls the next restart of Db2. BACKOUT=NO indicates that Db2 is not to execute the backward-log-recovery phase when it restarts. The ENDRBA option indicates that 000000010000 is the last RBA of the log that is to be used during restart. Any log information in the bootstrap data set, the active logs, and the archive logs with an RBA that is greater than this RBA is discarded.

CRESTART CREATE,BACKOUT=NO,ENDRBA=000000010000

Example 4: Assigning an IP address to a communication record

The following control statement specifies that DSNJU003 is to update the communication record in the BSDS with an IP address:


//DSNTLOG  EXEC PGM=DSNJU003,COND=(4,LT)
//STEPLIB  DD DISP=SHR,DSN=DSN1310.DB2.SDSNLOAD
//SYSUT1   DD DISP=OLD,DSN=DD00LOG.DD00.BSDS01
//SYSUT2   DD DISP=OLD,DSN=DD00LOG.DD00.BSDS02
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD * 
 DDF LOCATION=DD00,RESPORT=55001,PORT=55000,SECPORT=0
 DDF IPV4=9.82.28.164,GRPIPV4=9.82.28.164
 DDF NOIPNAME

Example 5: Adding a communication record to the BSDS

The following control statement specifies that DSNJU003 is to add a new communication record to the BSDS. The location, LU name, and password values are all provided.

DDF LOCATION=USIBMSTODB22,LUNAME=STL#M08,PASSWORD=$STL@290

Example 6: Updating a communication record with a secure TCP/IP port number in the BSDS

The following control statement specifies that DSNJU003 is to update the communication record in the BSDS to specify a secure TCP/IP port.

DDF LOCATION=XYZ,SECPORT=448

Example 7: Adding a communication record with an alias to the BSDS

The following control statement specifies that DSNJU003 is to add a communication record to the BSDS. The location, alias, LU name, and password values are all provided.

DDF LOCATION=USIBMSTODB22,ALIAS=STL715A1,STL715A2,LUNAME=STL#M08,PASSWORD=$STL@290

Note: The alias is an SQL identifier and should follow the rules of SQL identifiers. The identifier can not include special characters when you are naming a location alias.

Example 8: Adding multiple aliases and alias ports to the BSDS

The following control statement specifies five alias names for the communication record in the BSDS (MYALIAS1, MYALIAS2, MYALIAS3, MYALIAS4, and MYALIAS5). Only MYALIAS2 and MYALIAS5 support subsets of a data sharing group. Any alias names that were specified in a previous DSNJU003 utility job are removed.

DDF ALIAS=MYALIAS1,MYALIAS2:8002,MYALIAS3,MYALIAS4,MYALIAS5:10001

Example 9: Specifying a point in time for system recovery

The following control statement specifies that DSNJU003 is to create a new conditional restart control record. The SYSPITR option specifies an end RBA value as the point in time for system recovery for a non-data sharing system. For a data sharing system, use an end LRSN value instead of an end RBA value. This point in time is used by the RESTORE SYSTEM utility.

//JOBLIB  DD  DSN=USER.TESTLIB,DISP=SHR                  
//        DD  DSN=DSN910.SDSNLOAD,DISP=SHR               
//STEP01 EXEC PGM=DSNJU003                               
//SYSUT1 DD DSN=DSNC910.BSDS01,DISP=OLD                  
//SYSUT2 DD DSN=DSNC910.BSDS02,DISP=OLD                  
//SYSPRINT DD SYSOUT=*                                   
//SYSIN  DD *                                            
  CRESTART CREATE,SYSPITR=04891665D000                   
/*

To indicate that a SYSPITR restart is to be done without log truncation, specify a SYSPITR value of all 'FFs in the DSNJU003 job with the CRESTART parameter.

//STEP1 EXEC PGM=DSNJU003
//SYSUT1 DD DSN=DSNC910.BSDS01,DISP=OLD
//SYSUT2 DD DSN=DSNC910.BSDS02,DISP=OLD
//SYSPRINT DD SYSOUT=
//SYSIN DD 
CRESTART CREATE,SYSPITR=FFFFFFFFFFFFFFFFFFFF
/*

During the subsequent restart, the user will be asked to confirm the conditional restart with the following:

DSNJ256I ) DSNJW6 CONDITIONAL RESTART RECORD INDICATES SYSPITR
					RESTART WITH NO LOG TRUNCATION
DSNJ11I ) 	CONDITIONAL RESTART RECORD 1 CREATED AT 7.214 7:56
					WAS FOUND. REPLY Y TO USE, N TO CANCEL

Example 10: Removing aliases from a communication record

The following control statement specifies that no alias names apply. Any alias names that were specified in a previous DSNJU003 utility job are removed.

DDF NOALIAS

Example 11: Deactivating a data sharing member

The following control statement specifies that DSNJU003 is to deactivate a data sharing member.

DELMBR DEACTIV,MEMBERID=3