I/O operations are usually most critical for DB2 performance (or any other database for that matter).

kckinney

 Profile Answers by kckinney Questions by kckinney

• May 25th, 2007

I'm sorry, but the answer is a firm "It depends."Depending on various factors, most MVS boxes run short on either CPU or I/O. These factors include, workload, time of day, day of the week, etc. A ca...

Answer Question  Select Best Answer

Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.

senthil k

• Dec 26th, 2006

In datawarehouse environment, mostly all the tables are semi- normalized ( ie it is fully normalized) to reduce no of joins . so de-normalization is having lot of advantages in datawarehouse .

Answer Question  Select Best Answer

To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 9th, 2012

Lock contention are used for maintaining concurrency in the DB2? environment.There are several types of contention situations that degrade DB2 performance, including suspension, timeout, and deadlock.
Begin program-specific programming interface information.

Answer Question  Select Best Answer

Azahar

• Dec 15th, 2005

Cursor stands to the first record sorted by the field given in order by clause of cursor declaration.

Peter

• Oct 24th, 2005

Cursor point the first record.

Answer Question  Select Best Answer

seema nair

• Apr 4th, 2006

Use IDCAMS DELETE utility in first step of JCL to delete all the files as shown below//STEP0005 EXEC PGM=IDCAMS               ...

Saradha

• Oct 13th, 2005

Use IEFBR14 with DISP=(MOD,DELETE,DELETE). This is a dummy utility, just to make sure that atleast one EXEC statement is present in the JOB. DISP=(MOD,DELETE,DELETE) will delete the dataset, if i...

Answer Question  Select Best Answer

Azahar

• Dec 15th, 2005

Loading a DB2 table can be done by an utility as mentioned above or u can code a program and insert all the records data from a file by dynamic sql commands validating for all the fields.Eg:EXEC ...

pradipta

• Sep 9th, 2005

You can use LOAD utility(DSNTIAUL) to load data to DB2 tables.

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You keep track of changes you have done to the row later on update back to your orginal data.Col1------0Update tbl1 set col1 = 1where key1 = 111Col1-----1Update tbl1set col1 = 0where key1 = 111Col1If you have update many rows then you need to load the table again.-----
0

Answer Question  Select Best Answer

umapathi

• Jul 21st, 2006

hi the above said answer is correct  but selection criteria to usage should be T

pradipta

• Sep 9th, 2005

Go to file-aid copy option.Enter the from dataset to be copied and to dataset to which you want to copy.go to options. Enter 0 at Initial records to skip field.Then enter 3 at the no of records to skip field and 1 to no of records to select.press enter and PF3.

Answer Question  Select Best Answer

siva kumar

• Nov 24th, 2005

The Severity error in production support means the Job abended and sucessor jobs are holding the because of this job.(This is related to batch not for onlines)

Raju

• Sep 12th, 2005

severity one error means its a critical error and need to solve as priority basis.As per my support if number of user ecected  is more than 24 then error will be Sev1 and need to sove withing 7 hours

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Reuse means you can use the same cluster for further use. Remember it alternate index doesn't support for reuseble cluster.Upgrade means when the base cluster is opened for processing then the alternate index is updated automatically.

Answer Question  Select Best Answer

kckinney

 Profile Answers by kckinney Questions by kckinney

• Jun 8th, 2007

Could you provide some more information? Your question assumes we know what you've asked previously.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

Keep it simple. The DB2 catalog is under the schema SYSIBM (along with a whole lotta other stuff as well).

Krishna

• Nov 14th, 2005

Meta data information is stored in the sysibm schema. sysibm schema holds the database information and this schema exists for each database and holds the tables, columns, procedures and others that a user creates under that database.

Answer Question  Select Best Answer

jitendraprajapati

• Jan 25th, 2007

Try this --All PK and Constraints Select * from SYSCAT.COLUMNS;--All references (FK)Select * from SYSCAT.REFERENCES;

Regards,
Jitendra

Answer Question  Select Best Answer

SspSsp

 Profile Answers by SspSsp Questions by SspSsp

• Oct 28th, 2009

The main difference between DB2 and DB2 UDB is that DB2 UDB has open DBMS connectivity to other open systems. I.e., though on a mainframe system, it can connect to Java, Unix and a variety of other op...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

During precompilation of a COBOL program with SQL queries, the SQL statements and COBOL codes are separated. The timestamp during precompilation helps in identifying the corresponding versions of thes...

Answer Question  Select Best Answer

sainathkb

 Profile Answers by sainathkb Questions by sainathkb

• Jul 25th, 2008

This error related to db2 table access, please check you have access to all?the table which are using in your program.I face this problem in my exp and? i resolved this by communicating with on-site and DBA

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Search for the table name in the DB2 table SYSIBM.SYSINDEXESSELECT * FROM SYSIBM.SYSINDEXES WHERE NAME = 'tablename'  OR CREATOR = 'creator name' ;

Answer Question  Select Best Answer

kalone

 Profile Answers by kalone Questions by kalone

• Jan 31st, 2010

DB2 pre-compiler extracts all the SQL stmnts from the appln prg and keeps them in  DBRM and comments those SQL stmnts (in the appln prg) and replaces them with a CALL.

Answer Question  Select Best Answer

a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2.
All the above can access DB2.

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 3rd, 2008

All the given environments caln access db2

Answer Question  Select Best Answer

a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 11th, 2008

DBD stands for database descriptor

Answer Question  Select Best Answer