Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / s

Package is a single bound DBRM which contains the SQL
statements of a single application program or subroutine.
The package is a executable internal code that contains
access paths computed by the optimizer.
Bound packages are stored in SPT01 tablespace of the
DSNDB01 directory.

Is This Answer Correct ?    5 Yes 2 No

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

Answer / shankar v

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

Is This Answer Correct ?    3 Yes 0 No

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

Answer / guest

The executable version of the package that will be loaded
in to the EDM pool resides in the DSNDB01 directory in SKPT
table. All information about the package is stored in the
DB2 catalog table, SYSIBM.SYSPACKAGE.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More DB2 Interview Questions

What is the role of the data page in the db2 database?

0 Answers  


What is a bind card?

0 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,






What is the difference between oracle and db2?

0 Answers  


In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


Can you access the DB2 Directory table using SQL?

3 Answers  


what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,


How do you run JCL in cobol program

1 Answers   IBM, Syntel,


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  






Categories