Image copy for MSDB database

yogeshpawar · New User Joined: 01 Mar 2006 Posts: 37 Location: Sussex-UK

Hi,

Can you please let me know how can we take image copy for MSDB database? I think general image copy utility DFSUDMP0 cannot be used for this kind of database.

dick scherrer · Posted: Wed May 20, 2009 10:24 pm

Hello,

Suggest you speak with the ims dba.

yogeshpawar · New User Joined: 01 Mar 2006 Posts: 37 Location: Sussex-UK

I was told that it is not possible to take Image Copy by normal IBM utility used for taking image copy.

But I wonder if it is not at all possible to take image copy of MSDB database or is there any other way by which this can be done.

Any idea?

dick scherrer · Posted: Thu May 21, 2009 7:19 pm

Hello,

To repeat - talk to the ims dba.

In place, on your system, already are backup jobs. They just don't happen to be db2 Image Copy.

The dba can provide everything you need to make a backup copy on your system (and probably runs these with regularity).

Anuj Dhawan · Posted: Thu May 21, 2009 7:28 pm

You might like to check this link: Database Image Copy 2 Utility (DFSUDMT0).

yogeshpawar · New User Joined: 01 Mar 2006 Posts: 37 Location: Sussex-UK

Hi Dick,

I was told at our shop by DBA that it is not possible to take image copy of IMS MSDB database by the utility they generally use and no other way was suggested.

Hence I was trying to find is there any other utility present or any other way by which we can take image copy of this particular type of IMS databse.

Hi Anju,

Thanks for the link. But according to that document utility mentioned over there has got limitation and cannot be used to take image copy MSDB databse. Also couple of other utilities mentioned over there also cannot be used for taking image copy.

Maybe it is NOT possible to take image copy of such databases. Does anybody know about this?

enrico-sorichetti · Posted: Thu May 21, 2009 10:32 pm

did You read the
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DFSADBG4/CCONTENTS?SHELF=DFSSHCG3&DN=SC18-7806-03&DT=20071026153124
for MSDB considerations???

yogeshpawar · New User Joined: 01 Mar 2006 Posts: 37 Location: Sussex-UK

Thanks Eric.

The information which is of my use seeme to be following -

'At system checkpoint, a copy of all MSDBs is written alternately to one of the MSDB checkpoint data sets--MSDBCP1 or MSDBCP2. During restart, the MSDBs are reloaded from the most recent copy on MSDBCP1 or MSDBCP2. During an emergency restart, the log is used to update the MSDB. During a normal restart, the operator can reload from MSDBINIT using the MSDBLOAD parameter on the restart command.'

So there is nothing like taking Image Copy by running some job with Image Copy Utility as done for normal IMS database.