Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to recover a 'Z' table

former_member184029
Participant
0 Kudos

Moderator message - please do not use expressions like "Help!!!"

Hi

How can I do for recover a 'Z' table on AIX??

Thanks in advance.

Edited by: Rob Burbank on Apr 3, 2009 6:25 PM

10 REPLIES 10

Former Member
0 Kudos

Do you want to recover the table structure or the contents?

Rob

0 Kudos

I apologize for any words no permits!

I want to recover the contents

Thanks for answering

0 Kudos

Probably not much - you can ask your basis people if they can recover it from backup tapes.

Rob

0 Kudos

I'm with techical support, but they said that we only have backup until yestarday, they use TSM (IBM) and data base only see like a big back up.

0 Kudos

Then you will have to recreate rather than recover the data.

Rob

0 Kudos

Thanks to all for answering...

Rob in fact, I've had to make a program to restore all data.

Is there a way to make backup for 'Z' tables?

Regards

0 Kudos

You can make a new table with the same structure as the old. Then you need a program to copy data from the production version to the copy. You also need a program that will restore data back from the copy to the production version.

Rob

0 Kudos

Rob thanks for answering

But in my case, I had to get all flat files for each table and recorver all tables, I was wondering if is there a way to download 'Z' table content as backup.

0 Kudos

Sure - instead of creating a separate table, you could read the database table into an internal table and then use GUI_UPLOAD and GUI_DOWNLOAD to backup and restore the database table.

Rob

former_member194669
Active Contributor
0 Kudos

..

Edited by: a®s on Apr 3, 2009 7:33 PM