Hi All,

I need info about SQL logs .
Actually system is DB@ UDB on AIX. We are running short of space on the system . There are lot of files (log files) in the log directory.
In db config for my database path to log files is /portals/novainst/novainst/NODE0000/SQL00003/SQLOGDIR/

Now can I delete the previous log files to claim the space.?
ALso how exactly is the logging process is done. ? I mean any light on active logs and archive logs along with primary logs and secondary logs.

Also in DB2DIAG.LOG file I am getting the message as :

SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).
Detected on Container 0. ContPage= 72169l Obj=9 Type=128
SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).
Detected on Container 0. ContPage= 72700l Obj=9 Type=128
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table->size
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:real_size(3)
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:the_section
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:section ptr
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:section size
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:dynamic ptr

So does it mean that DB2 is itself taking care of SMS managed tablespaces . ?
Is this a big threat to database?

Thanks in advance
Deven.