Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Load a table ?? and what is Load replace ?
- 2 Answers
- 33550 Views
- Xansa, I also Faced
- E-Mail Answers
Answer Posted / karthikeyan@ibm
In General, system will have standard PROC(DSNUPROC) to
load the Table.Three symbolic parameter needs to be passed.
But only one parameter is mandatory SYSTEM=DB2T(subsystem).
Let me explain the Proc. The Proc contains a step with
DSNUTILB as program to load the table. In Parms, pass the
DB2 susbsystem. In SYSREC ddname points to the dataset that
contains the records to be load.SYSIN ddname points to the
control card that is used to load the table.Control card
contains information like tablename to be loaded, Position
of the column and other options like LOAD with REPLACE or
Load with RESUME, ENFORCE YES OR NO and LOG Yes OR NO.
When you want to specify REPLACE option, all the records or
rows in the table are deleted before loading and RESUME
option will retain the old records or rows in the table.
The tablespace will put in COPY PENDING status when you
load the table with Option LOG NO.
//DSNUPROC EXEC PGM=DSNUTILB,REGION=6144K,PARM='DB2'
//SYSREC DD DSN=&LOADdataset,DISP=OLD
//SYSIN DD DSN=&Controldataset,DISP=OLD
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Explain packages.
Explain db2.
What does db2 stand for?
What is the latest version of ibm db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How would you find out the total number of rows in a db2 table?
What is the syntax for FETCH in DB2 ?
Explain the benefits you can get from mainframe connect?
List out the buffer pools in db2
What action db2 takes when a program aborts in the middle of a transaction?
What is explain plan in db2?
What is copy pending status in db2?
What is performance tuning db2?
What is catalog database in db2?
