When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?

Answer Posted / shankar v

All Package related information are found in
SYSIBM.SYSPACKAGES catalog.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you stop a db2 database in linux?

554


define clustering index.

607


Define declaration generator (dclgen).

654


What is the use of db2 optimizer?

597


How to test SQL -911 error while developing COB-DB2 program

6684






Explain the contention situations caused by locks?

580


How do I start db2 in windows?

546


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1798


Highlight all the advantages that are attached to a package.

611


Can you use max on a char column?

628


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1789


What is dpf in db2?

653


Explain the benefits you can get from mainframe connect?

512


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694


What is the syntax for creating a table in the db2 database?

614