What can the Locate option of the Repair Utility accomplish?

Question Posted / guest

2 Answers
5751 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What can the Locate option of the Repair Utility accomplish?..

Answer / s

LOCATE is used to specify a particular page,RID,Key.

Is This Answer Correct ?

0 Yes

0 No

What can the Locate option of the Repair Utility accomplish?..

Answer / sreesh

Locate block in a reparir utility is used to lopcate a
page,RID, key in an INDEX etc.
The locate statement can be follwed other repair statement
like DELETE.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB2 Interview Questions

What is dclgen in db2?

0 Answers

What is page size in db2?

0 Answers

How will you return the number of records in table?

0 Answers

What is the difference between a package and a plan?

6 Answers Infosys, L&T, Mphasis,

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers

What information is held in SYSIBM.SYSCOPY?

1 Answers

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers IBM,

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers

Mention some fields that are a part of sqlca.

0 Answers

How do I add a column in db2?

0 Answers

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

For more DB2 Interview Questions Click Here