What is buffer pool and list some of them?

1028

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2388

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

What is bind plan?

1048

What are the full forms of spufi and dclgen and why are they used?

1087

What is the role of data manager in the db2 database?

1107

What is lock escalation in db2?

1031

Is db2 a database?

968

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535

What is a trigger in the db2 database?

1080

What is the difference between spufi and qmf?

1130

What does runstats do in db2?

1117

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

What is sqlca’s maximum length?

1186

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102