Can you access the DB2 Directory table using SQL?

Answer Posted / prasad botu

no user cant access data in db2 directory by sql but it db2
can access it for its internal purpose...

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the physical storage length of the data types date, time, and timestamp?

857


What is runstats and reorg in db2?

1014


What are types of indexes?

773


How many databases can be created inside an instance in db2 ?

808


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2086


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

903


What is buffer pool and list some of them?

789


Explain how can you do the explain of a dynamic sql statement?

847


What is db2? Explain.

779


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

813


What is the difference between nvl and coalesce?

807


Why cursor is used in db2?

760


Explain dclgen.

933


What is the latest version of ibm db2?

960


define clustering index.

800