aravindhan

• Oct 8th, 2015

Code
 

This query running 5 minutes. This is called performance tuning.

sagar reddy

• Apr 1st, 2015

Verifying weather a query is performing well or not

Answer Question  Select Best Answer

Difference between char and varchar datatype

lauren

• Aug 26th, 2015

DATE - x(8)
TIME - x(6)
TIMESTAMP - X(26)
INT
SMALLINT

Surya Pemasane

• Mar 27th, 2015

VARCHAR is variable-length.

CHAR is fixed length.

Answer Question  Select Best Answer

In the process of DB2 compilation after bind process will packages be created first or plan?

Rudresh

• Aug 3rd, 2015

Package

abhi_siddu

 Profile Answers by abhi_siddu Questions by abhi_siddu

• Aug 3rd, 2015

* Preparing executable from DB2 side is bind.
* Either directly bind DBRM in to plan or indirectly bind DBRM into package or plan
* Bind package is recommanded

Answer Question  Select Best Answer

-

Phanikiran Siddineni

• Jul 5th, 2015

TableSpace is Obviously physical entity as the storage of complete table is table space. however table is just a logical part . you can find LDS files of the tablespaces in system.

pooja singh

• Jun 15th, 2015

Both are logical entity.

Answer Question  Select Best Answer

IRLM is a module of DB2 which does1 Logging2 Thread creation3 Concurrency control using locking4 both logging and thread creation

sagar reddy

• Apr 1st, 2015

Concurrency control using locking

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

3. Concurrency control using locking

Answer Question  Select Best Answer

i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True

Gilbert

• Mar 3rd, 2015

Both are true

Rishu

• Aug 9th, 2014

3 ii) is Only True

Answer Question  Select Best Answer

?a.Check if equal to NULLb.Use null indicator, 0 indicates nullc.Use null indicator, -1 indicates nulld.Use null indicator, -2 indicates nulle.None of the above.Use null indicator, -1 indicates null

PRACHI

• Feb 13th, 2015

Place a null indicator variable in front of the host variable for the nullable column in the query, A value of -1 inidcator null value retrieved

Rishu

• Aug 12th, 2014

0:- Not Null
-1:- Null Value
-2:- Null value because of some conversion error

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

Rishu

• Aug 12th, 2014

LOW-VALUE = X00 which are hexadecimal zeros.
HIGH-VALUE = XFF which are hexadecimal ones.

sc60900

 Profile Answers by sc60900 Questions by sc60900

• Oct 31st, 2008

High-Values & Low-Values are ALPHANUMERIC Figurative Constants in COBOL. These are non printable characters which are having highest and lowest values respectively in a collating sequence.

Answer Question  Select Best Answer

DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.

Rishu

• Aug 10th, 2014

DDL:- Create, Alter, Drop etc...
DML:- Select, Insert, Update, Delete, Declare, Open, Fetch, Close etc...

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

DDL - Data Definition Language - Used to create/alter/delete Database objects DML- Data Manipulation Language - Used to insert/delete/update/select the data in the database obects(table/views...)

Answer Question  Select Best Answer

A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread

Lalit Pant

• Jul 10th, 2014

The answer is thread. The thread is used by the DB2 to pass the results of the query to the application program.
SQLCA is the set of variables that are used by DB2 to pass the status and error messages of the query execution to the program and are used in error routines and paragraphs.

prachi patankar

• Jun 22nd, 2014

SQLCA

Answer Question  Select Best Answer

Gurumoorthy K

• Jul 3rd, 2014

No, you cant use SUM on char columns. But few other functions can be used like MAX, MIN etc.

daniel.epps

 Profile Answers by daniel.epps Questions by daniel.epps

• Apr 20th, 2012

Yes

Answer Question  Select Best Answer

madhavan

• Mar 10th, 2014

SELECT * FROM Table_Name order by column_name desc Fetch first 5 rows only;

Mohit

• May 28th, 2012

There is nothing called "fetch last n records only" in db2...

You can use select col1 from table1 order by col1 desc fetch first 5 records only

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

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

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

Embedded SQL -> Access Path is generated during BIND time. also table authorizations are checked during BIND (if VALIDATE(BIND) is used).

Dynamic SQL => Access path is generated during Run-time. Table authorizations can only be checked during run-time.

kalone

 Profile Answers by kalone Questions by kalone

• Feb 1st, 2010

STATIC sql(embedded) : It is hardcoded in the program itself and the changeable                   &n...

Answer Question  Select Best Answer

An access path is the method used to access data specified in DB2 sql statements.

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

DB2 Access path is (in most cases) the path which results in the most optimized execution of an SQL query. Whenever any Static SQL (Embedded SQL) is bound to a package/plan, the DB2 optimizer creates...

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

The access path is determined by DB2 during the bind process. This determines what indexes will be used.

Answer Question  Select Best Answer

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

Check Pending is when you have data added to the table using either insert or LOAD utility which violate table check constraints. The IBM DB2 LOAD UTILITY has ENFORCE CONSTRAINTS and similar options w...

Mohit

• May 28th, 2012

SET INTEGRITY Option....please read IBM libraries before using this.

Answer Question  Select Best Answer

What are the important bind parameters to be used in bind card? What is the significance of each parameter?

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

I will say the Answer Depends barring a few parameters which are mostly used. 1) ISOLATION -> Isolation Level to decide level of locking used along with LOCK parameters on the DB2 objects. 2) ACQUI...

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

The bind parameters are generally generic the most important is isolation level which is always CS and sometimes UR if you want to rock right thru.

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