Interested to Buy Any Domain ? << Click Here >> for more details...
how to take the back up of the DB2 table.
- 7 Answers
- 22071 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 |
What is dclgen (declaration generator)?
What is the advantage in De-normalizing tables in DB2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
When DB2 connection fails, will online program work or give errors.
What is a thread?
Which component is responsible for db2 startup and shutdown?
What is dbrm? When it will be created?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
In a DB2-CICS program which is acts as co-ordinator and which is participant?
how to copy the host variables from ps file into cobol program other than include statement
How to compare data between two tables in db2?
What is meant by isolation level?
COBOL 
