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 |
Which is faster delete or truncate?
What is the latest version of ibm db2?
how will you retrieve first record in table
What is the advantage in De-normalizing tables in DB2?
What is concurrency in db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How do I optimize a query in db2?
How do I add a column to a table in db2?
What does the REORG Utility do?
What is ACQUIRE/RELEASE in BIND?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Name the different types of Table spaces.