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
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
|Is This Answer Correct ?||5 Yes||2 No|
Answer / shankar v
All Package related information are found in
|Is This Answer Correct ?||3 Yes||0 No|
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|
What is the role of the data page in the db2 database?
What is a bind card?
what is the difference between where clause and having clause
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
Can we use select * statement in cobol program without giving field names ???
What is the difference between oracle and db2?
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?
Can you access the DB2 Directory table using SQL?
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)
How do you run JCL in cobol program
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the difference between CS and RR isolation levels?