Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    78

    Unanswered: z/os db2 what datasets do i need from smpe for db2 to run?

    at this organization, after the smpe work was done, the following datasets were moved from the smpe environment to the db2 environment. then db2 was taken down and all the datasets were renamed. this seems like way to many datasets to me. how many of these datasets are really needed?

    RENAME 'DB22.ADSNLOAD.V9' 'DB22.ADSNLOAD'
    RENAME 'DB22.ADSNMACS.V9' 'DB22.ADSNMACS'
    RENAME 'DB22.SDAHBASE.V9' 'DB22.SDAHBASE'
    RENAME 'DB22.SDAHSLIB.V9' 'DB22.SDAHSLIB'
    RENAME 'DB22.SDDABASE.V9' 'DB22.SDDABASE'
    RENAME 'DB22.SDSNBASE.V9' 'DB22.SDSNBASE'
    RENAME 'DB22.SDSNC.H.V9' 'DB22.SDSNC.H'
    RENAME 'DB22.SDSNCLST.V9' 'DB22.SDSNCLST'
    RENAME 'DB22.SDSNDBRM.V9' 'DB22.SDSNDBRM'
    RENAME 'DB22.SDSNEXIT.V9' 'DB22.SDSNEXIT'
    RENAME 'DB22.SDSNIVPD.V9' 'DB22.SDSNIVPD'
    RENAME 'DB22.SDSNLOAD.V9' 'DB22.SDSNLOAD'
    RENAME 'DB22.SDSNLOD2.V9' 'DB22.SDSNLOD2'
    RENAME 'DB22.SDSNMACS.V9' 'DB22.SDSNMACS'
    RENAME 'DB22.SDSNPFPE.V9' 'DB22.SDSNPFPE'
    RENAME 'DB22.SDSNPFPK.V9' 'DB22.SDSNPFPK'
    RENAME 'DB22.SDSNSAMP.V9' 'DB22.SDSNSAMP'
    RENAME 'DB22.SDSNSPFM.V9' 'DB22.SDSNSPFM'
    RENAME 'DB22.SDSNSPFP.V9' 'DB22.SDSNSPFP'
    RENAME 'DB22.SDSNSPFS.V9' 'DB22.SDSNSPFS'
    RENAME 'DB22.SDSNSPFT.V9' 'DB22.SDSNSPFT'
    RENAME 'DB22.SDSNXML.V9' 'DB22.SDSNXML'
    RENAME 'DB22.SDXRRESL.V9' 'DB22.SDXRRESL'
    RENAME 'DB22.SDXRSAMP.V9' 'DB22.SDXRSAMP'
    RENAME 'DB22.SDXXADM.V9' 'DB22.SDXXADM'
    RENAME 'DB22.SDXXC.V9' 'DB22.SDXXC'
    RENAME 'DB22.SDXXCLI.V9' 'DB22.SDXXCLI'
    RENAME 'DB22.SDXXCLP.V9' 'DB22.SDXXCLP'
    RENAME 'DB22.SDXXCMD.V9' 'DB22.SDXXCMD'
    RENAME 'DB22.SDXXDAD.V9' 'DB22.SDXXDAD'
    RENAME 'DB22.SDXXDBRM.V9' 'DB22.SDXXDBRM'
    RENAME 'DB22.SDXXDTD.V9' 'DB22.SDXXDTD'
    RENAME 'DB22.SDXXH.V9' 'DB22.SDXXH'
    RENAME 'DB22.SDXXJCL.V9' 'DB22.SDXXJCL'
    RENAME 'DB22.SDXXJDBC.V9' 'DB22.SDXXJDBC'
    RENAME 'DB22.SDXXLOAD.V9' 'DB22.SDXXLOAD'
    RENAME 'DB22.SDXXSDDF.V9' 'DB22.SDXXSDDF'
    RENAME 'DB22.SDXXXML.V9' 'DB22.SDXXXML'

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I'm not sure... but I think you can look at the master address space (or jcl for it - I think the default location is sys1.proclib) to see what gets loaded during db2 startup.

    Example from master address space:

    15:42:44 IAT4401 LOCATE FOR STEP=xxxxMSTR DD=STEPLIB DSN=DB2.DSNT.DSNEXIT
    15:42:44 IAT4402 UNIT=3390 ,VOL(S)=DB2PM1
    15:42:44 IAT4401 LOCATE FOR STEP=xxxxMSTR DD=STEPLIB DSN=DB2.DSNT.DSNLOAD
    15:42:44 IAT4402 UNIT=3390 ,VOL(S)=DB2PM1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •