On Thursday 06 August 2009, SUBSCRIBE IBM-MAIN Neo wrote: > We are trying to use DFSMSdss that provides dump and restore services that > can be used on DB2 data sets. > (We are trying to avoid coding of image copies or table unloads that will > take up coding effort and a lot of space to hold the data. We want the > tapes to be used efficiently and so to pack many tables into one tape.) > > Currently we've only dumped tablespace, indexspace from the DB(dump & > restore jobs RC=0). After restore job complete, we got DB2 -904 error when > we want to access those table spaces.(-904 means the table space is no > longer available.) > > So my questions are: Does DFSMSdss dump/restore equire any other > components of the table space be dumped and restored together to keep db2 > happy? > Anything else I've missed? What's the exact process if we want to use > DFSMSdss to dump/restore DB2 data sets? Maybe there is a DB2 list you can ask this to. But in effect you've chosen to externally manage your DB2 table spaces. This means that if you restore with something like DFDSS, you need to first:
1) DB2 DROP the table spaces 2) Restore the table spaces with DFDSS 3) DB2 CREATE the table spaces 4) DB2 CREATE the tables That's my experience anyway, such as it is. Regards, Richard ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
