manoj pingale

• Dec 8th, 2005

The indexset and the sequence set are the two sets of records in the index component of the vsam KSDS the other being the data component. The sequence set contains pointers to each CI within the&...

Answer Question  Select Best Answer

Nick

• Nov 30th, 2005

The Checkpening is referential integrity is in doubt or its check constraints are violated. To remove need to run CHECK data utility.Copy pending - LOAD places a table space in the copy pending status. to remove need to take the backup on a table space

Answer Question  Select Best Answer

siva kumar

• Nov 24th, 2005

We can abend the program based on certain conditons.If the condition is satisfied call the program 'ILBOABN0' using abned code.CALL 'ILBOABN0' USING U0165.

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

Saradha

• Oct 14th, 2005

Commonly, 1 byte of space is assigned to each digit/char.But if declared as 'Packed Decimal' (also known as COMP-3), then 2 digit occupy only 1 byte.i.e if X = 78, then only 1 byte is assigned to X, rather than 2 bytes space.

Answer Question  Select Best Answer

Nimesh

• Oct 4th, 2005

u can display index in DB2 using syscat.sysindexes & syscat.syskeys system tablesthe common linking columns in the tables being tbname (table name) and tbcreator.

Answer Question  Select Best Answer

prem

• Sep 20th, 2005

By create single plan and two packages.

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

An intent lock is at the table level for a segmented tablespace or at the tablespace level for a nonsegmented tablespace. They indicate at the table or tablespace level the kinds of locks at lower levels.

kalyan satya A

• Jun 7th, 2005

How to eliminate duplicate rows from a table leaving one from the duplicates

Answer Question  Select Best Answer

Shayer

• Jun 6th, 2005

Index is a mechanism that allows to search data quickly. In SQL Server 2000, two kinds of index are there : 1 : Clustered Index (only one) 2: Non Clustered Index(up to 249)

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