Search found 14 matches

by Chandra Shekar G R
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...
by Chandra Shekar G R
Thu Apr 19, 2007 2:00 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Various Locking mechanism for cursors and other SQL?
Replies: 3
Views: 15688

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...
by Chandra Shekar G R
Wed Apr 18, 2007 11:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Various Locking mechanism for cursors and other SQL?
Replies: 3
Views: 15688

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?
by Chandra Shekar G R
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?
by Chandra Shekar G R
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?
by Chandra Shekar G R
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??
by Chandra Shekar G R
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?
by Chandra Shekar G R
Wed Apr 11, 2007 11:03 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 29158

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...
by Chandra Shekar G R
Wed Apr 11, 2007 10:46 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 29158

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...
by Chandra Shekar G R
Wed Apr 11, 2007 10:46 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 29158

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...
by Chandra Shekar G R
Wed Apr 11, 2007 10:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 29158

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...
by Chandra Shekar G R
Wed Apr 11, 2007 12:27 am
Forum: OTHER SUBJECTS
Topic: Mainframe Simulator
Replies: 3
Views: 17249

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?
by Chandra Shekar G R
Tue Apr 10, 2007 11:26 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM LDS used in DB2
Replies: 1
Views: 9629

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?
:roll:

Regards,
Chandra
by Chandra Shekar G R
Tue Apr 10, 2007 11:15 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 29158

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...