How to find the number of rows in db2 tables?
Write a program that uses move corresponding.
What are the two ways in which dl/i interface can be invoked?
What is ims (db/dc)?
What is load utility in db2?
What is defragmentation and what is its advantage?
Can you explain function of dbctl?
Give the format of using and giving in sort statement. What are the restrictions with it?
I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?
Are there any set of rules for the names of the steps used in a job?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is dbrm? What it contains? When it will be created?
What is a ci split? What is a ca split?
How to pass the parameter in parm using linkage section ? (syntax)?
when an xctl is done, does the tranid change ? Is a new task created ? Does it cause an implicit syncpoint to be issued ?