What are the uses of db2 optimizer?

663

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 ?...

3634

What is meant by explain?

533

How do you find the maximum value in a column in db2?

521

Explain various types of locks in db2?

518

What does reorg do in db2?

441

What is the difference between oracle and db2?

466

What is the latest version of ibm db2?

568

What do you mean by commit and rollback?

453

What do you mean by storage group (stogroup)?

471

What is the syntax for seeing the columns and data types of a table in the db2 database?

457

Can one database have multiple instances?

455

What is dpf in db2?

507

What type of database is db2?

410

What is load replace in db2?

435