how to take the back up of the DB2 table.
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 |
Describe what a storage group(STOGROUP) is?
What are the different types of base tables?
What is a bind card?
wt is view ? wht r the restrictions for view ?
What is the function of logging in the db2 database?
why we create view.
Can SQL statements/queries be included in a copybook?
What is normalization and what are the five normal forms?
Where besides the DB2 catalog is database object information stored by DB2?
what is consistency token
What is the difference between plan and package in db2?
Can one database have multiple instances?