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

What are bind parameters in db2?

970

---

What is the role of schema in the db2 database?

1175

---

Is ibm db2 open source?

1010

---

Outputs of explain are with matchcols = 0. What does this signify?

988

---

What is the use of value function?

1070

---

What is a collection in db2?

978

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2166

---

Can one database have multiple instances?

1003

---

How can the duplicate values be eliminated from db2 select?

1039

---

Can we insert update delete in view?

908

---

Is db2 a mainframe?

965

---

What is the difference between nvl and coalesce?

1009

---

What is difference between isnull and coalesce?

1005

---

What is the difference between cursor stability and repeatable read isolation levels?

1112

---

What is access path in db2?

923

---