Databases not only write actual data in tables, it also writes control information, object space map for the objects in that tablespace. So database needs full access on that tablespace directory/datafiles and its underlying files wherever your tablespace files exist.
First, switch back the permission for .DAT & .INX to original.
Second, You can implement this requirement by setting appropriate privileges.
sansaniwal12
Last Activity: Jul 28 '08, 02:15 PM
Joined: Sep 26 '07
Location:
-
How to invoke db2top in batch mode
I have installed db2top on solaris 10 and i trying to run db2top in batch mode. I tried with following option for batch mode:
db2top -d UBIS -u db2das -p db2das -i 3 -b l -X -o db2top.xml -m 10
But still this utility runs in interactive mode.
could someone suggest me how can i run db2top in batch mode.
Best Regards,
Deepak Sansaniwal -
how to execute runstats in stored procedure
Hi,
we want to execute runstats for all database tables in one go.In db2 v9, there is no such option to run runstats schema vise or for complete database.So,can we execute runstats from a stored procedure. -
Execute runstats in a stored procedure
Hi,
we want to execute runstats for all database tables in one go.In db2 v9, there is no such option to run runstats schema vise or for complete database.So,can we execute runstats from a stored procedure.
No activity results to display
Leave a comment: