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 |
What DB2 Catalog column tell you when an index needs table reorganized ?
what is the role of the cursor in db2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
my project is insurance management system,how to explain my work environment in interview?
What is db2 plan table?
What is a storage group (stogroup)?
How does cobol compile db2 program?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
Explain about rct.
What does runstats do in db2?
What is sqlcode -922 ?