what are the max. & min. no. of partitions allowed in a
partition tablespace?
Answers were Sorted based on User's Feedback
Answer / s
The maximum number of partitions allowed in DB2 V8 is 4096
partitions.
Is This Answer Correct ? | 3 Yes | 6 No |
How would you print the output of an SQL statement from SPUFI?
What are the three lock types?
when does the SQL statement gets executed when you use cursor in the application programming ?
What is the information associated with sysibm.syslinks table?
What is the meaning concurrency in the db2 database?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
What are some SQL aggregates and other built-in functions?
What is lock escalation?
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?