SHANKAR

• Dec 31st, 2006

BY USING HANDLE AID.

kaushikee

 Profile Answers by kaushikee Questions by kaushikee

• Jun 7th, 2006

Hi,   I am little confused, to find this ques. in DB2 section. If it is for CICS the ans. is as follows:   The Execution Interface Block(EIB) has a field called EIBAID which contai...

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

For performance tuning for your COBOL/DB2 program you need to follow COBOL & DB2 standrads along with your organization standards.

Raja

• Aug 22nd, 2006

1. Make sure the SQL query is coded as simply and efficiently as possible.Make sure that no unused columns are selected and that there is nounneeded ORDER BY or GROUP BY. 2. Indexable predicates:...

Answer Question  Select Best Answer

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

A

kalone

 Profile Answers by kalone Questions by kalone

• Feb 1st, 2010

To improve the performance following are some of the tips :1. Always use FOR UPDATE OF when updating with a cursor.2. Use WHERE CURRENT OF to delete a single row.3. Check the SQLCODE after each SQL statemnt.4. Avoid using WHENEVER.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

It does not make any difference that you are defining cursor in working storage section or in procedure division. You can define it in both places. If you are defining a cursor in procedure division it doesn't affects at all of your Cobol/db2 program.
Regards,
Pradeep

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

There is no difference in declaring a cursor in working storage or procedure division.  The only constraint with declaring a cursor is that it should be done before any OPEN CURSOR statement.

Answer Question  Select Best Answer

. It is a write to disk that may occur before or long after a commit. The write is controlled by the buffer manager.

krsna

• Jun 7th, 2012

Asynchronous write is when the pages from bufferpool is written to disk by the page cleaners.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 6th, 2012

Asynchronous write is a function where the the function call immediately returns after the operation was enqueued or if before this happens an error was encountered.This function is present in "aio.h"...

Answer Question  Select Best Answer

A lock is the mechanism that controls access to data pages and tablespaces.

Raghunathan Asari

• Jul 23rd, 2007

Lock is a DB2 mechanism by which DB2 can provide Concurrency and Consistency at  the same time(not exactly).  Based on the SQL statement DB2 provides diffe...

Sukanya Srinivas

• Apr 20th, 2007

Lock is one of the component of DB2. IRLM(IMS-DBe Resource lock Manager) used for data locking and unlocking. Lock is of two types. 1) Share lock 2) Exclusive?Lock?????? A) Share lock...

Answer Question  Select Best Answer

Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2?

chpastor3

 Profile Answers by chpastor3 Questions by chpastor3

• Jun 12th, 2008

The 4 lock units are Row, Page, Table (if segmented), and Table space. Christine Pastor 

burelamanohar

• Feb 6th, 2007

Two transactions A & B enter into dthe DEADLOCK state whan a transaction A which has locked an object X , waits on an object Y locked by transaction B which itself is waiting for X.

Answer Question  Select Best Answer

A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly portrays a business situation. Unfortunately, it requires extra coding for an application program to handle this situation.

arijit.seth

• Sep 29th, 2007

A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a c...

burelamanohar

• Feb 6th, 2007

A NULL value indicates the absence of a column value in a row.A NULL value is not the same as ZERO or all BLANKS.

Answer Question  Select Best Answer

A view is a virtual table made up of data from base tables and other views, but not stored separately.

chandra kanth ganga

• Nov 10th, 2006

View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating views while using joins.

vijay saxena

• Oct 24th, 2006

A view table is virtual or logical table which depends on base table by using this the filtered records may be accessed frequently.

Answer Question  Select Best Answer

Tables are stored in tablespaces (hence the name)! There are three types of tablespaces: simple, segmented and partitioned.

Tarik khan

• Aug 30th, 2011

Tablespace is Logical group of datafiles in a database. A database typically contains at least one tablespace, and usually two or more. Within the database.

Sukanya Srinivas

• Apr 20th, 2007

Any database contain one or more Table spaces. Each Table space is devided into pages of size 4kb or 32kb. Each table psace can have one or more tables. TABLE SPACE SPACE IS UNIT OF RECOVERY OR REORGANIZATION.

There are 3 types of Table Spaces
a) Simple
b) Segmented
c) Partitioned

Answer Question  Select Best Answer

Raghuram

• Jul 17th, 2007

In the process of DB2 program preparation, it is necessary to have the DB2 subsystem up during Bind process.It is during Bind, that the Stripped out SQL statements are checked for any errors and ...

javid

• Mar 21st, 2006

DB2 mustbeup at  Bind Stage.

Answer Question  Select Best Answer

Mahaveer

• Feb 2nd, 2014

Code Program-idIS INITIAL PROGRAM
If IS INITIAL is coded along with program id of of sub program then the program will be in intial stage every time it is called
OR CANCEL is issued after CALL will set the sub program to initial state

GZ

• Apr 2nd, 2006

variables might already be in initiated state due to first run.

Answer Question  Select Best Answer

arivu

• Dec 1st, 2006

How does you get record no from 5 to 15 from a dataset of 100 records?        

SreeHari

 Profile Answers by SreeHari Questions by SreeHari

• Nov 15th, 2005

Hi,From File-Aid Main  Menu Choose option Browse or Edit and press enterWhere we suppose give physical file name and copybook name and copy book path and also At the bottom there is option '...

Answer Question  Select Best Answer

srini1

 Profile Answers by srini1 Questions by srini1

• Jul 3rd, 2006

You should use cobol defined variable RETURN-CODE in you cobol program

srini

• Jul 3rd, 2006

Hi,you should move the value to cobol defined variable RETURN-CODE

Answer Question  Select Best Answer

amit

• May 29th, 2006

Also QUERY TABLE command will tell  you if load is complete or not

Saleem Kidwai

• May 23rd, 2006

Use DB2I command. Option 7.TO CHECK STATUS OF DATABASE (IT IS READ or READ/WRITE ETC)-DIS DB(*) SPACE(*) For eg,to check whether TABLESPACE PXXXXXXX.PZZZZZZZ IS IN CHECK PENDING, GIVING FOLLOWING :-DIS DB(PXXXXXXX) SPACE(PZZZZZZZ)       

Answer Question  Select Best Answer

kaviarasu

• Jun 13th, 2006

DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after exec...

KAVIARASU

• Jun 13th, 2006

DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after exec...

Answer Question  Select Best Answer

pinaki

• Dec 7th, 2006

a package/dbrm is binded to a plan after compilation of a cobol-db2 / cics-cobol-db2 program.a dbrm is produced during precompile step.usually dbrm is associated to a package and package is binde...

umapathi

• Sep 6th, 2006

plan - it can contain packages and dbrms. package- it contains only dbrms. it is advantageous and cost effective.

Answer Question  Select Best Answer

pjagannatha032

 Profile Answers by pjagannatha032 Questions by pjagannatha032

• Feb 18th, 2006

IF YOU CREATE A PRIMARY KEY IT IS MANDATORY THAT YOU SHOULD CREATE AN INDEX FOR THAT TABLE ON THAT PRIMARY KEY,WITHOUT WHICH YOU CAN NOT ACCESS THE TABLE

pradipta

• Feb 3rd, 2006

INDEX is generally used to make query access faster.It also takes less time for execution b'use it will not go for searching all the data's in the table.It will search only by using that IND...

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

To answer the original question, for many releases only one column could appear in the result table of a subquery.  As of Version 7 of DB2 the result of a subquery is equivalent to a fullselect which means that 750 columns can appear.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

Sorry guys but those are not DB2 metrics. In DB2 Version 8 the max length of a row is 32K not 64K. The max number of tables in a join is 225 (for many releases 15 tables was the max but not any more, ...

Answer Question  Select Best Answer

Prasad

• Nov 22nd, 2006

Hi,Both the above ways can be selected.If u want to load the table with some data u can use load utility.If u want to move some value in the prog then u can go for the host variables. 

javid

• Mar 21st, 2006

By utilising Load Utility.

Answer Question  Select Best Answer