If the main program has only cobol statements and subprogram
has the db2 statements what is the procedure for
precompilation. for which program we need to do the
precompilation
What is reorg and runstats in db2?
Request to database but database is not available so what is was abend is raised?
What is ibm db2 database?
What are union and union all?
Why do we need reorg in db2?
Define data page.
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Mention the location where the output received from explain statement is stored.
What is reorg in database?
How to access db2 tables in mainframe?
What are simple, segmented and partitioned table spaces ?
Is ibm db2 open source?