how to take the back up of the DB2 table.
- 7 Answers
- 19487 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / none
In JCL, We can Use DSNTUAIL Utility to downLoad the Tables
in to Sequential Dataset.
we have to Wirte the Program (DSNTUAIL) and it's Plan in to
SYSTIN
And write the Query into SYSIN clause
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / avinash
You can take up the back up of the DB2 table using the DB2
File Aid option 3.7 using the foreground of online or batch.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ranju
I think the utility name given above is incorrect.For
unloading data from table to dataset(table backup) the
utility used is INZUTILB.
For loading data to the table the utility used is DSNUTILB
Correct me if im wrong
| Is This Answer Correct ? | 1 Yes | 4 No |
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
How many buffer pools are available in db2?
How will fetch last 5 rows from table in db2
How to create backup table in db2?
What is the function of logging in the db2 database?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What do the initials DDL and DML stand for and what is their meaning?
What is a db2 schema?
What is pagespace?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is cursor stability?
Can we able to find all the Table names under a Particular Plan?
COBOL 
