What is meant by locked space? Describe locking concepts?

vjjammi

 Profile Answers by vjjammi Questions by vjjammi

• Aug 25th, 2010

DB2 Supports Locking mechanism at three levels. 1. Space Level. 2. Table Level. 3. Page Level. The above hierarchy has some significance and in order to lock a page at the higher level, you needn&#...

Answer Question  Select Best Answer

Can we divide it row wise or col wise.?is there any query for this.?

Mohit

• May 28th, 2012

You can table partitioning feature

Answer Question  Select Best Answer

shiv

• May 7th, 2012

4141... in decimal

Answer Question  Select Best Answer

If any DB2 column changed,how impact analysis can be done fo this?

asharm37

 Profile Answers by asharm37 Questions by asharm37

• Sep 20th, 2014

Impact Analysis for DB2 table change: 1.What is changing-If it is column size then find out all the programs using that column in them.ADJUST THE CODE ACCORDINGLY.If working storage value is being po...

Answer Question  Select Best Answer

How and why to use restart checkpoint logic. I am not able to understand the concept of checkpoint restart logic. please anyone explained it to me.

Sai

• Jan 27th, 2016

Check point, we have a check point for each run. or example if we are running some 100 data to be processed and we our job failed. Here in the check point we would have kept a check or every 10, so if...

Answer Question  Select Best Answer

How to find the occurrence of letter A in the name field of a table using SQL?

sudamj

• Apr 20th, 2016

INSTR function will help if you mean to search A in the column value and NOT in table name

Answer Question  Select Best Answer

How to handle a non-matching column (which is NULL) in outer joins. My site standards prevent the use of Null indicator.

Shanthi G

• Jan 29th, 2019

If any column is null we need to declare null indicator of S9(04) comp for that . if you not mention null indicator while fetching record that is null it shows -305 error.

Answer Question  Select Best Answer

The FREE command can be used to delete plans and/or packages no longer needed.

burelamanohar

• Feb 6th, 2007

PCTFREE : It allows for insertion of new records and for expansion of variable length fields.

FREEPAGE : The number of pages to be loaded between each page left free. It is useful for finding a near page for inserting a new record.

JAVID

• Mar 27th, 2006

Free Command is meant for the deletion of plans. A single free command can delete max. of 12 packages.welcome for feed back

Answer Question  Select Best Answer

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.

burelamanohar

 Profile Answers by burelamanohar Questions by burelamanohar

• Feb 7th, 2007

Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

Amol

• Sep 2nd, 2006

Partitioned table is clustered by clustering index

Answer Question  Select Best Answer

An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.

greeshmavarghese

 Profile Answers by greeshmavarghese Questions by greeshmavarghese

• Oct 7th, 2009

Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.? Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu

Answer Question  Select Best Answer

An application plan or package is generated by the bind to define an access path.

Ramya

• Sep 22nd, 2011

The optimized access path is called plan.... plan contains multiple packages / access path's. plan is a optimized access

path to extract the data from the tables.

Narender

• Aug 29th, 2006

DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths.

Answer Question  Select Best Answer

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

1. WHERE clause is used to filter the result set records with different predicates like -- BETWEEN, =, = and many more....2. WHERE Clause is used to Isolate rows.

mahadev mahajan

• Sep 30th, 2005

 where clause is use to extrct only one record.it is used with GROUP BY CLAUSE.     EG:-SELECT DNO FROM EMP WHERE SAL=4200         ...

Answer Question  Select Best Answer

hemant

• Apr 18th, 2006

i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) .

pradipta

• Feb 3rd, 2006

As many no of column's that table is having that many no. of indexs we can pass.

Answer Question  Select Best Answer

prasata

• Feb 2nd, 2006

Go to spool and in the command prompt give owner  '@XXXX' and pre * then you will able to see all the job status for the user XXXX. where XXXX is the mainframe id of other person.

yogaraj

• Dec 27th, 2005

But.. if  and only that person mention your id in their program(NOTIFY=&UR ID)... you can view the status of  that person 's job otherwise you can't .. i think it may be right...

Answer Question  Select Best Answer

seema nair

• Apr 4th, 2006

The command TSO XPED should take you to Xpediter main screen

Azahar

• Dec 15th, 2005

For Xpediting a program first a cmnddio load should be created.Then give xp where u can give the load lib and xped ur program

Answer Question  Select Best Answer

AR

• Mar 16th, 2007

Its not a tool. Its REPAIR utility.

kp

• Jun 8th, 2006

By using tool called REPAIR.

Answer Question  Select Best Answer

Apurbita Roy Majumder

• Oct 16th, 2007

It is similar to the sequential read but here first a pointer is set and then the file is read from that particular record. For example:START file name KEY >= file key ( Ke...

manoj

• Sep 29th, 2006

 VSAM files can be read and write same like cobol files. But only difference is you have to give the dsn path of your vsam file in jcl step while compile time.  select empfile assign to dd1  dd1 will have the dsn parameter with vsam file path.try it manoj.

Answer Question  Select Best Answer

gokul

• Jun 13th, 2006

could u pls expalin a little more on locationcollectionpackage versionregardsGokul.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

A package has a 4 part name:location: collection id: package name: versionThe collection id is not a place but rather a qualifier that allows a group of packages (i.e. those bound to that collection) ...

Answer Question  Select Best Answer

gokul

• Jun 13th, 2006

hi folks,collection: set of packages with a collection idversion: it refers to a package created at a particular time.(ie) if the same package is created at a later time with no changes it will be a d...

javid

• Apr 10th, 2006

Hi Sataya!My Question is What is Collection and Version.I know both are associated with packages.But am in confusion.plz clear me.

Answer Question  Select Best Answer

rupesh

• Feb 22nd, 2007

Select constrint_name,constraint_type,search_condition from user_constraintswhere table_name='name of table in upper case';

hemant

• Apr 18th, 2006

SELECT * FROM SYSIBM.SYSCOLUMNS WHERETBNAME=table-name AND TBCREATOR=' creator-name';orto see column names, types and lengthsSELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';  the above queries can be used 

Answer Question  Select Best Answer