On the create tablespace, what does the CLOSE parameter do?
Answer / s
CLOSE YES parameter tells DB2 that when DB2 needs to close
datasets when DSMAX is reached, DB2 will choose this
tablespace to be closed.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the picture clause of null indicator variable?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is dpf in db2?
What is ibm db2 used for?
how to resolve -811
What is the role of the data page in the db2 database?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What happens in bind step in a db2 program?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is the STOSPACE Utility used for?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the maximum size of a char data type in db2?