Answer Posted / saeed
clustering index attempts to maintain a particular order of
data, it try to keep newly inserted rows clustered
according to an index and avoid page splits.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How and when does the db2 enforces the unique key?
Explain about open switch business continuity software?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How do you select a row using indexes in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are concurrency issues?
How to restart a DB2 program?
What is the purpose of rollback and commit?
How to find the maximum value in a column in the db2 database?
What is clone table?
How connect db2 database to datastage?
How can you find out the # of rows updated after an update statement?
Define data page.
