Search found 14 matches
- Fri Apr 20, 2007 9:41 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Locking Heirarcy and Compatibility?
- Replies: 1
- Views: 8646
Locking Heirarcy and Compatibility?
Can somebody explain the locking heirarchy & compatibility amont various locking mechanism. Take an example where you have a table in a tablespace with EXCLUSIVE and you have multiple programs accessing the same table with different Isolation level. Not sure if the above example helps you but I will...
- Thu Apr 19, 2007 2:00 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Various Locking mechanism for cursors and other SQL?
- Replies: 3
- Views: 15693
I understand the locking mechanism with isolation levels. I know there are various other ways of achieving locks through Tablespace or through overrides (LOCK statement) but what is not clear to me is among these locking mechanisms (isolation level, tablespace, override,...) which one takes preceden...
- Wed Apr 18, 2007 11:58 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Various Locking mechanism for cursors and other SQL?
- Replies: 3
- Views: 15693
Various Locking mechanism for cursors and other SQL?
Can somebody help me understand various locking mechanism that DB2 implements for cursors and other SQLs?
On what basis DB2 decides which lock to use?
On what basis DB2 decides which lock to use?
- Wed Apr 18, 2007 12:52 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: IJKEFT01 or IJKEFT1A
- Replies: 1
- Views: 8558
IJKEFT01 or IJKEFT1A
While running a DB2 program in batch which one do we use IJKEFT01 or IJKEFT1A? What is the difference?
- Tue Apr 17, 2007 10:24 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Calling a COBOL DB2 subroutine using non-DB2 program
- Replies: 1
- Views: 9739
Calling a COBOL DB2 subroutine using non-DB2 program
How do I call a COBOL DB2 subroutine using non-DB2 COBOL program in a JCL? Is it like any non-DB2 program?
- Mon Apr 16, 2007 10:49 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Finding PLAN(or Package)
- Replies: 6
- Views: 18189
Finding PLAN(or Package)
I have an existing program and how can I know my particular program is using particular "PLAN" when my system has many plans already??
- Mon Apr 16, 2007 10:45 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Updating a Table?
- Replies: 4
- Views: 11701
Updating a Table?
Is it possible to update a table without using COBOL(any)/DB2 program, SPUFI,QMF, Princeton, any other tools etc?
- Wed Apr 11, 2007 11:03 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29159
When you say bind package into a plan to make packages executable, only those executable gets stored in a plan. Can I have some programs directly bound into a plan and some programs bound into the same plan via package? Another questions - if you have mulitple programs bound directly into a plan, wh...
- Wed Apr 11, 2007 10:46 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29159
When you say bind package into a plan to make packages executable, only those executable gets stored in a plan. Can I have some programs directly bound into a plan and some programs bound into the same plan via package? Another questions - if you have mulitple programs bound directly into a plan, wh...
- Wed Apr 11, 2007 10:46 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29159
When you say bind package into a plan to make packages executable, only those executable gets stored in a plan. Can I have some programs directly bound into a plan and some programs bound into the same plan via package? Another questions - if you have mulitple programs bound directly into a plan, wh...
- Wed Apr 11, 2007 10:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29159
When you say bind package into a plan to make packages executable, only those executable gets stored in a plan. Can I have some programs directly bound into a plan and some programs bound into the same plan via package? Another questions - if you have mulitple programs bound directly into a plan, wh...
- Wed Apr 11, 2007 12:27 am
- Forum: OTHER SUBJECTS
- Topic: Mainframe Simulator
- Replies: 3
- Views: 17253
Mainframe Simulator
I am on a lookout for Mainframe Simulator software so that I can install the software in my laptop and practice. Can anybody know where I can get that?
- Tue Apr 10, 2007 11:26 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM LDS used in DB2
- Replies: 1
- Views: 9630
VSAM LDS used in DB2
Recently I learnt that DB2 uses a VSAM's Linear DS for managing the tablespace. Is this true? If True then KSDS,ESDS,RRDS are known to be a far better VSAM dataset against LDS why can't DB2 use them instead of LDS?
Regards,
Chandra
Regards,
Chandra
- Tue Apr 10, 2007 11:15 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29159
PACKAGE VS PLAN ?
I know that while executing a DB2 program plan is used. But Packages are preferred over plan when you are binding a program for various advantages over Plan. What I did not understand is if packages are preferred but we still need to bind the package into a plan in order to make the package executab...