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 a lock?
What are db2 objects?
In terms of DB2 indexing, what is the root page?
How can record locking be achieved in those DB2 versions which do not support it?
How do I start db2 in windows?
What is the picture clause of null indicator variable?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
how can u nderstand the sql stmts executed successfully or not ?
What is ibm db2 connect?
Can SQL statements/queries be included in a copybook?
Can we update view in db2?
How do you retrieve the data from a nullable column?