BMC Load REPLACE option

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

BMC Load REPLACE option

Post by hparthas » Sat Aug 20, 2011 1:55 pm

Hi All,

I tried to load my Dev table and my table had some lakhs of records, now, unknowingly I used the below Load card to load the database.

Code: Select all

LOAD REPLACE                                         
   LOG NO                                           
   ORDER YES                                         
   COPY YES 
   UPDATEDB2STATS YES                               
   BMCSTATS YES                                     
   REDEFINE NO                                       
   INTO TABLE ABCD.TABLE_1_TEST
Unfortunately I load all my old data in the table. I tried to find if any IC or QUISECE for my table, and I have not taken any.

Can you tell how to recover the old data which was in my table before i load it. I'm worried about the old data.

Many Thanks in advance or your input.

Thanks,
HK

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sat Aug 20, 2011 10:05 pm

Did you create a backup of the old data before loading the current data? If not, why not . . . ?

Suggest you talk with your storage management people and see if there is a disaster recovery backup or other backup that has the old data and make a plan to recover it. Many (most?) organizations run full-volume backups periodically.
Have a good one

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Sun Aug 21, 2011 7:58 am

Thanks for your suggestion. Since this is a Dev data, i don't think that there will be some backup for my database. I will check with Storage mgmt team if they run any scripts for this at back end for all Dev databases.

I checked whether there is any Full image copy for my database. I could not find any.

Any other suggestions to recover my database would be great ?

Thanks,
HK

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sun Aug 21, 2011 8:45 am

Well, you have destroyed whatever was in there.

If there is no backup i don't know of any way to get it back. . .

Can you re-run the processes that use some sequential data to insert/load into the missing table(s)?

If not, suggest you come up with a way to have the initial data available (after you recreate it) and make sure there is a periodic backup of your data so that you can get it back. Just because the storage management might not backup your test data is no reason for it not to be backed up.

Most organizations have realized that the IT developers are the most expensive department in the organization and not treating thier data as valuable as production is quite foolish. . .
Have a good one

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Sun Aug 21, 2011 9:17 am

Let me try to recover by database with my available files. Good that I have few files. Henceforth, I will schedule a job to take full image copy of my database periodically.

Thanks for your suggestion.

thanks,
HK

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sun Aug 21, 2011 1:18 pm

You're welcome - good luck :)
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others