Answer Posted / s.v.venkata sivaprasad
reorg is a db2 use to improve the performance and any unused
pages in table space is rearange it perticul order and
release free space
//job1 job....
//step1 exec pgm=IKJEFT01
//sysin dd *
reorg db123.tb123
//
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What action db2 takes when a program aborts in the middle of a transaction?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the maximum length of sqlca?
What is null in db2?
When do you specify the isolation level?
What is host variable in db2 cobol?
Explain about rct in db2?
How do you select a row using indexes in db2?
What are the prerogatives?
What is db2 instance?
List out the data types available.
What is the meaning concurrency in the db2 database?
What type of database is db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Give a brief description of db2 isolation levels?