Administrator's Reference

DSMSERV LOADDB (Reload the Database)

Use this command to reload a dumped TSM database in optimal order. No other server activity is allowed while reloading the database. Perform the applicable steps in this order:

  1. When recovering from a failure, reinstall TSM using the DSMSERV FORMAT command and creating a new database and recovery log. This keeps the original database and log volumes intact in case you must repeat the dump and load.

    Run a modified version of the install job (PGM=ANRSERV,PARM='/FORMAT') to reinitialize the recovery log and database datasets. A sample job named ANRINST is provided in the ASAMPLIB dataset.

    Attention: Do not reinitialize DISK storage pool volumes.

  2. Save the current sequential volume history to a file. The load process regresses the sequential volume history information.

  3. The DSMSERV LOADDB command specifies a device class to be used when reading the database information. Ensure that a device configuration file that includes the definitions for this device class and for any required libraries and drives is available.

  4. Issue the DSMSERV LOADDB command.

  5. A message at the end of the output from the DSMSERV LOADDB indicates if you must audit the database. If the server was quiesced when it was halted and the DSMSERV DUMPDB was issued, you do not need to audit the database. Otherwise, you must issue the DSMSERV AUDITDB command to ensure that the database is returned to a synchronized state after it is reloaded. If there was any storage pool volume activity after the dump, audit the volumes by using the AUDIT VOLUME command.

Syntax

>>-DSMSERV LOADDB----+-DEVclass--=--device_class_name--+-------->
                     '-dump_name-----------------------'
 
                           .-,-------------.
                           V               |
>-------VOLumenames--=--+----volume_name---+-+-----------------><
                        '-FILE:file_name-----'
 

Parameters

DEVclass
Specifies the device class to be used when reading the database information. You must specify either a dump name or a device class.

dump_name
Specifies the name of the location where the dumped database data is stored. You must specify either a dump name or a device class. Use the following format.

DD:ddname
Specifies the file name of the dumped database data to be restored. Use the same name specified in the DSMSERV DUMPDB command. A ddname is the 1-6 character data definition name created by the JCL DD statement.

VOLumenames (Required)
Specifies the volumes needed to load the database. Possible values are:

volume_name
The names of the volumes. To specify multiple volumes, separate the names with commas and no intervening spaces. List the volumes in the order in which they were used for the DSMSERV DUMPDB command.

FILE:file_name
The name of a file that contains a list of the volumes. Each volume name must be on a separate line in the order in which they were used for the DSMSERV DUMPDB command.

You can also specify the volume list as an in-stream data set by specifying the data set's DD name with this parameter, and including the data set in the JCL. You must include DD: when you specify this parameter, for example:

volumenames=file:dd:vollist

Examples

Task 1

Load the database from the DB0001 tape.

Sample JCL:

//LOADDB  JOB  ,REGION=40M,TIME=1440,CLASS=A,MSGCLASS=H
//ADSMDB  EXEC PGM=ANRSERV,PARM='/LOADDB DEV=CART VOL=ST0076',
//            DYNAMNBR=300,
//            TIME=NOLIMIT
//STEPLIB  DD DSN=EDC.V2R1M0.SEDCLINK,DISP=SHR
//         DD DSN=SYS1.LINKLIB,DISP=SHR
//         DD DSN=PLI.SIBMLINK,DISP=SHR
//         DD DSN=ADSM.LINKLIB,DISP=SHR
//OPT      DD DSN=ADSM.OPTIONS,DISP=SHR,FREE=CLOSE
//DSMAMENG DD DSN=ADSM.ANRMSG(ANRMENU),DISP=SHR
//HLPAMENG DD DSN=ADSM.ANRHLP(ANRHENU),DISP=SHR
//DSK      DD DSN=ADSM.DISKLOG,DISP=SHR

Task 2

Load the database from the file ARIZONA.S0303570.DLD, in the device class named FLAT.

Sample JCL:

//LOADDB  JOB  ,
            REGION=40M,TIME=1440,CLASS=A,MSGCLASS=H
//ADSMDB  EXEC PGM=ANRSERV,DYNAMNBR=300,TIME=NOLIMIT,
//  PARM='/LOADDB DEVCLASS=FLAT VOL=ARIZONA.S0303570.DLD'
//STEPLIB  DD DSN=EDC.V2R1M0.SEDCLINK,DISP=SHR
//         DD DSN=PLI.MINI.SIBMLINK,DISP=SHR
//         DD DSN=SYS1.LINKLIB,DISP=SHR
//         DD DSN=ADSM.LINKLIB,DISP=SHR
//OPT      DD DSN=ADSM.OPTIONS,DISP=SHR,FREE=CLOSE
//DSMAMENG DD DSN=ADSM.ANRMSG(ANRMENU),DISP=SHR
//HLPAMENG DD DSN=ADSM.ANRHLP(ANRHENU),DISP=SHR
//DSK      DD DSN=ADSM.DISKLOG,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTERM  DD SYSOUT=*

Task 3

Load the database from the DBDATA tape dataset.

Sample JCL:

  //LOADDB  JOB  ,REGION=40M,TIME=1440,CLASS=A,MSGCLASS=H
  //ADSMDB  EXEC PGM=ANRSERV,PARM='/LOADDB VOL=FILE:DD:DBDATA',
  //            DYNAMNBR=300,
  //            TIME=NOLIMIT
  //STEPLIB  DD DSN=EDC.V2R1M0.SEDCLINK,DISP=SHR
  //         DD DSN=SYS1.LINKLIB,DISP=SHR
  //         DD DSN=PLI.SIBMLINK,DISP=SHR
  //         DD DSN=ADSM.LINKLIB,DISP=SHR
  //OPT      DD DSN=ADSM.OPTIONS,DISP=SHR,FREE=CLOSE
  //DSMAMENG DD DSN=ADSM.ANRMSG(ANRMENU),DISP=SHR
  //HLPAMENG DD DSN=ADSM.ANRHLP(ANRHENU),DISP=SHR
  //DSK      DD DSN=ADSM.DISKLOG,DISP=SHR
  //* -------------------------------------------------------
  //* LOAD The Database from a tape
  //* -------------------------------------------------------
  //DBDATA   DD UNIT=B38,DISP=OLD,LABEL=(,SL),VOL=SER=ST0077,
  //         DSN=ADSM.DUMPDB.DATA,DCB=(RECFM=U,LRECL=32760)


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]