DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 9th, 2012

By using the concept of list prefetch DB2 uses multiple index processing.I is used to satisfy multiple predicates in a select statement that are joined by an AND or OR.

Answer Question  Select Best Answer

A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two columns in a table. If two columns in a table will often be accessed together a composite index will be efficient.

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 12th, 2007

If an index is  created  on more than  one column  ,which r frequently used in where clause of  select statement.  it will show the  effect in increace in performance .

Answer Question  Select Best Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 9th, 2012

Self-referencing constraint makes the table both the parent and dependent table in the same referential constraint.
Here the table is created first and then the foreign key is defined to that table.

Answer Question  Select Best Answer

No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.

rayadurgamsudha

 Profile Answers by rayadurgamsudha Questions by rayadurgamsudha

• Mar 11th, 2007

No the view need not be redone. the changes done in base table will be seen in the view too this is the feature of a view. any manipulations, adding , deleting is done to the base table the changes are seen in the view without being redone.

Answer Question  Select Best Answer

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated. The synonym is linked to the AUTHID that created it.

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.An...

Answer Question  Select Best Answer

Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.

muamee

 Profile Answers by muamee Questions by muamee

• Jun 14th, 2010

Normalization in DB2 is used to reduce data redundancy and maintain integrity.There are 4 types normalization1st type: Every instances of an entiry should contain only one value.2nd type: Each at...

Answer Question  Select Best Answer

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.

neha

• Jul 6th, 2007

Foreign Keys are keys used in a table as an attribute and are primary keys of some other table

Answer Question  Select Best Answer

samiha

• Aug 25th, 2005

SELECT statement is used for selecting a particular items or all items from a table...it is as desired by the user.  FROM statement is used to to tell the table name.  WHERE statement is used to specify a particular condition while choosing the values

samiha

• Aug 25th, 2005

SELECT statement is used for selecting a particular items or all items from a table...it is as desired by the user.  FROM statement is used to to tell the table name.  WHERE statement is used to specify a particular condition while choosing the values

Answer Question  Select Best Answer

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