If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / lu
when u bind , 5 queries has 5 sql statements in 1 DBRM, its
regroup into 1 package, 1 plan...Plan is a collection of
packages..
correct me if i'm wrong..
Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
Before you give the explain statement, what are the prerogatives?
What does a deadlock mean in DB2?
How would you find out the total number of rows in a db2 table?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is package in cobol db2?
What does runstats do in db2?
Is db2 a mainframe?
Why select is not preferred in embedded sql programs?
What is image copy in db2?
What is load utility in db2?
Define predicate?
What is view db2?
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 ?...
What is explain plan in db2?
List down the types of triggers in the db2 database?