What is a DB2 access path?



What is a DB2 access path?..

Answer / guest

It is used to determine efficient way to access db2 tables.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More DB2 Interview Questions

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


What is a db2 package?

0 Answers  


What is dbrm? What it contains? When it will be created?

0 Answers  


What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


What is CHECK PENDING ?

5 Answers  


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  


Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  


What is Declaration Generator(DCLGEN)?

1 Answers  


Categories