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 does the RUNSTATS Utility do?
Mention data types used in db2 ?
Give the COBOL definition of a VARCHAR field.
What is CHECK PENDING ?
What are leaf pages?
What is subquery ?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
Explain db2.
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is access path in db2?
What is isolation level?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?