Probably RUN STATS is not done and the program is using a wrong index due to incorrect stats. Probably RUNSTATS is done and optimizer has chosen a wrong access path based on the latest statistics. Read More

A VARCHAR column REMARKS would be defined as follows: ... 10 REMARKS. 49 REMARKS-LEN PIC S9(4) USAGE COMP. 49 REMARKS- TEXT PIC X(1920). Read More

For three reasons: If the table structure is changed ( a field is added ), the program will have to be modified Program might retrieve the columns which it might not use, leading on I/O over head. The chance of an index only scan is lost. ... Read More

a nonmatching index scan if ACCESSTYPE = I. Read More

Use IDCAMS DELETE utility in first step of JCL to delete all the files as shown below //STEP0005 EXEC PGM=IDCAMS //SYSOUT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSIN DD * ... Read More

DB2 Interview Questions - PART II Read More

Yes. Read More

SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=’ creator-name’; or to see column names, types and lengths SELECT NAME,COLTYPE, LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND ... Read More

File opening modes are Input mode , output mode, extend mode, inputoutput mode. Inputmode-------- "Read" the file outputmode--------"write" the record. extend mode--------"appeand" the records. i/o mode-------------"read or write" any... Read More

Move highvalues to the key of the VSAM file and the issue Readnext record command. Then give Readprev command. This will read thelast record. Read More

SELECT FIRSTNAME || ? ? || LASTNAME FROM EMP; Read More

DATE: 4bytes TIME: 3bytes TIMESTAMP: 10bytes Read More

CS: Releases the lock on a page after use RR: Retains all locks acquired till end of transaction Read More

The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT. Read More

1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB(’ED 01T.OBJ.LOADLIB’) END 2. Use IKJEFT01 utility program to run the above DSN command in a JCL.... Read More

The number of distinct values for a column is called index cardinality. DB2’s RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data. Read More

one divided by the number of distinct values of a column. Read More

We use cursor only when we updating existing records or Inserting Some Records to the Table. When you Using commit, in DB2 every single row will be commited after the process. If abend occurs only the cursor will be closed, we can start from last... Read More

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 CA....it stores the key value for the highest... Read More

It has to be in a CURSOR. Read More

Subprogram are reusable statements. If more than one program require the same statements to be repeated, then its better idea to place these statements in a new program and CALL them as subprograms. The result vary as what value u pass as parameter ... Read More

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. Read More

It is a data structure that must be included in any host- language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling codes and warnings. Read More

DeCLarations GENerator: used to create the host language copy books for the table definitions. Also creates the DECLARE table. Read More

1. Can lead to high space utilization if most of the values are close to maximum. 2. Positioning of VARCHAR column has to be done carefully as it has performance implications. 3. Relocation of rows to different pages can lead to more I/Os on... Read More

Similar to client-service applications testing, but you have to know how to operate basic TSO and ISPF commands and menus, view mainframe files, look at and use SDSF or other output tool, log on CICS and transactions, use FTP or another transfer... Read More

Tables related with a foreign key are called delete-connected because a deletion in the primary key table can affect the contents of the foreign key table. Read More

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables. Keys (columns) that exist on one table and that are primary keys on another table. Read More

This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a ’repeatable read’ holds all locks untile the transaction completes or a syncpoint is... Read More

A subquery in which the inner ( nested ) query refers back to the table in the outer query. Correlated subqueries must be evaluated for each qualified row of the outer query that is referred to. Read More

Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space. Read More

First CREATE MANAGER table with EMP# as the primary key. Then ALTER it to define the foreign key. When is the authorization check on DB2 objects done - at BIND time or run time? At run time. Read More

Bulit-in mathematical functions for use in SELECT clause. Read More

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 Read More

Use DECLARE CURSOR statement either in working storage or in procedure division(before open cursor), to specify the SELECT statement. Then use OPEN, FETCH rows in a loop and finally CLOSE. Read More

Using the utility IKJEFT01 in the JCL. Read More

When a column which contains long text, e.g. remarks, notes, may have in most cases less than 50% of the maximum length Read More

It is not mandatory to use DCLGEN. Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself ( because of the DECLARE TABLE ). DCLGEN being a tool, would generate accurate host variable definitions for the... Read More

SELECT statement has resulted in retrieval of more than one row. Read More

Synonym is an alternate name for a table or view used mainly to hide the leading qualifier of a table or view.. A synonym is accessible only by the creator. Read More

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur. Read More

Use SELECT DISTINCT ... Read More

PIC S9(9)V99 COMP-3. Note: In DECIMAL(11,2), 11 indicates the size of the data type and 2 indicates the precision. Read More

To take routine backup of tables After a LOAD with LOG NO After REORG with LOG NO Read More

A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility. Read More

When a table is LOADed with ENFORCE NO option, then the table is left in CHECK PENDING status. It means that the LOAD utility did not perform constraint checking. Read More

A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency. Read More

Only one. Read More

Not all of them. Some views are updateable e.g. single table view with all the fields or mandatory fields. Examples of non-updateable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY... Read More

No Read More

The column cannot have nulls. Use it for key fields. Read More

PCTFREE: percentage of each page to be left free FREEPAGE: Number of pages to be loaded with data between each free page Read More

Simple Tablespace: Can contain one or more tables Rows from multiple tables can be interleaved on a page under the DBAs control and maintenance Segmented Tablespace: Can contain one or more tables Tablespace is divided into segments of 4 to 64... Read More

The number of distinct values a column or columns contain. Read More

EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ). Read More

Recording SQL statements that access a table. Specified at table creation time or through alter. Interview Questions 1 | Interview Questions 2 | Interview Questions 3 | Interview Questions 4 | Interview Questions 5 | Interview Questions 6 | ... Read More

No. To lock a view, take lock on the underlying tables. Read More

SQL command used to change the definition of DB2 objects. Read More

PLAN has the executable code for the SQL statements in the host program Read More

They contain executable code for SQL statements for one DBRM. Read More

Collection is not a property of a plan. Collection is a property of a package. Within a plan there are package lists (PKLIST) which identifies collection and/or packages that are available through that plan. Collection is to package as schema is to... Read More

What I think we cannot see the comp-3 value by USAGE verb we have to type HEX ON in the command prompt of that particular file to see the number Example: Suppose the number is +12345. In the HEX ON screen we will see the number as ... Read More

Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space. Read More

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 Read More

YES Read More

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. Read More

Db2 must be up while running the program Read More

BETWEEN supplies a range of values while IN supplies a list of values. Read More

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

Record will be appeand in the file. Read More

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language can deal with only one row at a time. Read More

//JOB STATEMENT //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //DD1 DD DSN=DSRC239.KSDS.CLUSTER,DISP=SHR //DD2 DD DSN=DSRC239.NEW.PS,DISP=SHR //SYSIN DD * REPRO INFILE(DD1)- OUTFILE(DD2)- SKIP(499)- COUNT(401)... Read More

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row. Read More

DATE, TIME, TIMESTAMP? DATE: 4bytes TIME: 3bytes TIMESTAMP: 10bytes Read More

Cursor stability means that DB2 takes a lock on the page the cursor is accessing and releases the lock when the cursor moves to another page. Read More

Use SELECT MAX(... Read More

Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. Read More

1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes. Read More

The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It’s Y2K compliant). Read More

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

Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of a value Read More

SQLCODE, SQLERRM, SQLERRD Read More

A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment. Read More

Never. Such processing could produce duplicate values violating entity integrity. Primary keys must be updated one at a time. Read More

YES Read More

LIKE is used for partial string matches. ?%? ( for a string of any character ) and ?_? (for any single character ) are the two wild card characters. Read More

where clause is use to extrct only one record.it is used with GROUP BY CLAUSE. EG:-SELECT DNO FROM EMP WHERE SAL=4200 GROUP BY DNO; DISCRIPTION:- where dno is (dept. no) emp is (employi table), ... Read More

DDL(data definition language) DDL Statement are ? Create ? Alter and ? Drop DML(data manipulation language) DDL Statement are ? Select ? Insert ? Update and ? Delete ... Read More

Match for any single character. Read More

Disater recovery-literal meaning is the recovery of an entire application in the case of a disaster be it natural(like flood,storm,earthquake) or accidental(like fire etc). The main point is to recover the main jobs in theapplication to make sure... Read More

Dynamic SQL is a SQL statement created at program execution time. Read More

High resource utilization if large updates are to be done Read More

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... Read More

Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables. And updates of primary key values may require changes in foreign key values to maintain... Read More

1. Based on the lock-size given while creating the tablespace 2. Programmer can direct the DB2 what lock-size to use 3. If lock-size ANY is specified, DB2 usually chooses a lock-size of PAGE Read More

Plan is generated when you compile the DB2- SQL program. This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname) DBRM: Data base request module is generated by precompiler... Read More

No Read More

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. Read More

Primary : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key. Unique index: a physical object that stores only... Read More

Authorization failure Read More

This is generated when the consistency tokens in the DBRM and the load module are different. Read More

In userid.PLAN_TABLE Read More

USING HOST VARIABLE we can pass data from COBOL to DB2 Read More

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. Read More

Use SELECT COUNT(*) ... Read More

Yes Read More

Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs. Read More

It is not mandatory to use DCLGEN. Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself ( because of the DECLARE TABLE ). DCLGEN being a tool, would generate accurate host variable definitions for the... Read More

It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc., during pre-compile. Read More

No. Because the precompiler does not refer to the DB2 catalogue tables. Read More

Dynamic SQL is a SQL statement created at program execution time. Read More

100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes). Read More

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) Read More

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing the space. An update lock is less restrictive;... Read More

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 Read More

Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results. Read More

# of rows in the table Percent of rows in clustering sequence # of distinct values of indexed column # of rows moved to a nearby/farway page due to row length increase Read More

Version control tool will create only a version for changed program.Through this version we can find out the changed programs. ex:endevor Debugging tool is used to debug the error step by step. ex:xpeditor. Read More

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a... Read More

It is full backup of a DB2 table which can be used in recovery . Read More

TSO, CICS, IMS and BATCH Read More

SYNONYM: is dropped when the table or tablespace is dropped. Synonym is available only to the creator. ALIAS: is retained even if table or tablespace is dropped. ALIAS can be created even if the table does not exist. It is used mainly in... Read More

This column cannot have nulls and while insertion, if no value is supplied then it wil have zeroes, spaces or date/time depending on whether it is numeric, character or date/time. Use it when you do not want to have nulls but at the same time... Read More

When a column which contains long text, e.g. remarks, notes, may have in most cases less than 50% of the maximum length. Read More

1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement 2. Include EXPLAIN command in the embedded dynamic SQL statements Read More

Use a question mark in place of a host variable ( or an unknown value ). e.g. SELECT EMP_NAME FROM EMP Read More

CS: Cursor Stability RR: Repeatable Read Read More

ISOLATION LEVEL is a parameter for the bind process. Read More

PAGE, TABLE, TABLESPACE Read More

SHARE, EXCLUSIVE, UPDATE Read More

DBRM: DataBase Request Module, has the SQL statements extracted from the host language program by the pre-compiler. PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM. Read More

Plan is marked as invalid. The next time the plan is accessed, it is rebound. Read More

I am little confused, to find this ques. in DB2 section. If it is for CICS the ans. is as follows: The Execution Interface Block(EIB) has a field called EIBAID which contains the value of the last AID pressed. EIB is included in the linkage section... Read More

If it is the number of DASDs you want to know, then it is 133 DASDs. Read More

1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid cost of a large bind 3. Avoid the entire transaction being unavailable during bind and automatic rebind of a plan 4. Minimize fallback complexities if changes result in... Read More

To retrieve the nth row from table you can code Query like SELECT * FROM TABLE-NAME WHERE NTH=(SELECT COUNT(*) FROM TABLE WHERE COUNT >2) IF WROUNGH FEED BACK ME Read More

Print the output dataset. Read More

Collection: set of packages with a collection id Version: 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 different version. there are two options for version add... Read More

Looks like index page split has occurred. DO a REORG of the indexes. Read More

I think what you mean is the DB2 catalog. Since the catalog database (DSNDB06) is a relational database made up of tables you "handle" it with SQL. Read More

Dynamic SQL is a SQL statement created at program execution time. Read More

At run time, when the PREPARE statement is issued. Read More

Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND Read More

Maximum number of columns in a table --> 256 Maximum lenght of a row in a table -- > 64KB Read More

S9(4) COMP. Read More

-1 : the field is null 0 : the field is not null -2 : the field value is truncated Read More

NDEX is generally used to make query access faster.It also takes less time for execution b’use it will not go for searching all the data’s in the table.It will search only by using that INDEX.INSEX is created on the column of a table.Then... Read More

To insert a NULL, move -1 to the null indicator To insert a valid value, move 0 to the null indicator Read More

A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path. It also collects statistics used for space management. These statistics are stored in DB2 catalog tables. Read More

After a load, or after mass updates, inserts, deletes, or after REORG. Read More

It is full backup of a DB2 table which can be used in recovery. Read More

Use SELECT DISTINCT ... in db2 query Read More

To take routine backup of tables After a LOAD with LOG NO After REORG with LOG NO Read More

Specify the indexed columns in the WHERE clause of db2 query. Read More

Use SELECT MAX(...) .. in db2 query Read More

Use DB2I command. Option 7. TO CHECK STATUS OF DATABASE (IT IS READ or READ/WRITE ETC) -DIS DB(*) SPACE(*) For eg,to check whether TABLESPACE PXXXXXXX.PZZZZZZZ IS IN CHECK PENDING, GIVING FOLLOWING : -DIS DB(PXXXXXXX) SPACE(PZZZZZZZ) ... Read More

SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP; Read More

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted. Read More

LOW-VALUES and HIGH-VALUES are figurative constants that represent the lowest and highest possible values for an alphanumeric data item. You would use them anytime you want to set or compare a data item to "all bits off" or "all bits on" values. ... Read More

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations 2. Substitute a numeric value for any nulls used in computation Read More

This is generated when the consistency tokens in the DBRM and the load module are different. Read More

UNION : eliminates duplicates UNION ALL: retains duplicates Both these are used to combine the results of different SELECT statements. Suppose I have five SQL SELECT statements connected by UNION/UNION ALL, how many times should I specify UNION to... Read More

NO Read More

TSO, CICS, IMS and BATCH Read More

Subroutines are generally used when same piece of ode is required in arious pgs It ay or may not have the business logic. Read More

LIKE is used for partial string matches. ?%? ( for a string of any character ) and ?_? (for any single character ) are the two wild card characters. Read More

To do partial search e.g. to search employee by name, you need not specify the complete name; using LIKE, you can search for partial string matches. Read More

Match for any single character. Read More

SELECT EMPNO FROM EMP WHERE PROJECT IS NULL; Read More

By create single plan and two packages. Read More

SELECT SUM(SALARY) FROM EMP WHERE QUAL=?MSC?; NULL Read More

By Using COND parameter in JCL.This parameter will automatically detect the return code from the calling program. By Using the RETURN-CODE field in the COBOL program. Read More

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... Read More

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) Read More

I think there is a command to alter the table space by which u can add containers or devices to ur existing table space........ We have to add or create containers in the TS. A TS can span more than one containes. Using Alter... Read More

Either by using the single row SELECT statements, or by using the CURSOR. Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL? - Single row SELECTs. Read More

See answer to next question. Read More

since during precompilation, a timestamp is given to both the COBOL code and DBRM, this will be identified at the time of execution. So, even a DBRM has to be bound. Read More

EXEC SQL SELECT A.EMP_ID ,B.WAGE FROM Table1... Read More

YES Read More

If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic). Read More

A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program. Read More

DCLGEN stands for declarations generator; it is a facility to generate DB2 sql data structures in COBOL or PL/I programs. Read More

Specify the indexed columns in the WHERE clause. Read More

Free Command is meant for the deletion of plans. A single free command can delete max. of 12 packages. Read More

SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level. Read More

SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP; Read More

SUBSTR is used for string manipulation with column name, first position and string length used as arguments. Eg. SUBSTR (NAME, 1 3) refers to the first three characters in the column NAME. Read More

The simplest DB2 index is the B-tree and the B-tree’s top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. Read More

Check the value stored in SQLERRD(3). Read More

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. Read More

EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ). Read More

Cascade rule is one of the RI constraint. Which allows deletion of FK from the Dependent table if the PK from the parent is deleted. If we try to delete record from the parent that is not in the child we will see abend code -532. Read More

A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It’s the DB2 equivalent of TBD on an organizational chart and often correctly portrays a business situation. Unfortunately,... Read More

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... Read More

Use a question mark in place of a host variable ( or an unknown value ). e.g. SELECT EMP_NAME FROM EMP WHERE EMP_SALARY > ? DB2 Interview Questions - PART III www.mainframegurukul.com Read More

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

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language can deal with only one row at a time. Read More

SQLCODE, SQLERRM, SQLERRD Read More

Probably RUN STATS is not done and the program is using a wrong index due to incorrect stats. Probably RUNSTATS is done and optimizer has chosen a wrong access path based on the latest statistics. Read More

YES we can use and Group by must come in order to code query.Ex. select * from tab01 group by col1 order by col02 Read More

Precompilor-: Precompilor’s main purpose is to check the syntactical error of COBOL programes which contains embeded SQL statements.It first compiles & then differentiates cobol & DB2 statements.It sends all the... Read More

100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes). Read More

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

These are part of the CICS-DB2 Interface. Dedicated threads are connections to DB2 that are always available to a particular application so that app doesn’t have to wait. High priority apps use dedicated threads. Pool threads are shared by... Read More

Make sure that the PLAN_TABLE is created under the AUTHID Read More

No Read More

During the BIND process. ISOLATION ( CS/RR )... I use CS and update a page. Will the lock be released after I am done with that page? No. Read More

Determine the point at which DB2 acquires or releases locks against table and tablespaces, including intent locks. Read More

a user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages. In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows. Read More

as an extra-byte prefix to the column value. physically, the nul prefix is Hex ?00? if the value is present and Hex ?FF? if it is not. Read More

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. Read More

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... Read More

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 SQL INSERT INTO Table1... Read More

From File-Aid Main Menu Choose option Browse or Edit and press enter Where we suppose give physical file name and copybook name and copy book path and also At the bottom there is option ’selection critiera’ where N-none ... Read More

Use SELECT COUNT(*) ... in db2 query DB2 INTERVIEW QUESTIONS DB2 SQL INTERVIEW Questions Read More

execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but 3.you know the sqlcode after executing the query. QMF: 1.you cannot execute more than one query. 2. In QMF result of the query u can?t... Read More

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... Read More

Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of on e table with all the clause in corresponding columns of the other table or tables. This kind of... Read More

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified Read More

By using tool called REPAIR. Read More

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. Read More

Whenever a component is retrieved from the production base to a package, the component automatically gets compiled and staged. If not, then you can restage/recompile (by issuing ’r’/’s’ command) the component after it is... Read More

DATE, TIME, TIMESTAMP? DATE: PIC X(10) TIME : PIC X(08) TIMESTAMP: PIC X(26) Read More

The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened. Read More

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. Read More

A DB2 bind is a process that builds an access path to DB2 tables. A DB2 bind is a process that builds an access path to DB2 tables Read More

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