Search results for query: *

Hi from version 8.1 on you have something called as health monitors and center you can use that to do this. You have to create health indicators for the tablespace and whenever it passes the threshold it send s out emails as u wanted. Search more for that. Find more about health center at...

hi, Friend I think u are looking for timestamp in the wrong place its not in mytble.table1. it should be in sysibm.sysdummy1 try this bye

Hi, you can also do this select 'alter table ',tabschema,'.',tabname, ' DROP Foreign key ', constname, ' ;' from syscat.tabconst where tabschema='URschema' and type='F' > script.dml this will give you a file called script.dml which will have all the ALTER Table commands for all tables in ur...

Yes it does give the size in bytes

Hi, You can check the table size by running a REORGCHK with update statistics. then one of the values displayed for each column is TSIZE that is the table size so just run runstats for the desire table. ## reorgchk update statistics on table schemaname.urtabname Remember to update your...

Hi, You can search on IBM website for tutorials on DB2 certification exams. You can start with exam num 700 and then do 701. 700 is basic Db2 info and 701 is for DB2 DBA's. The tutorials are good. And if you want to read the topics in details they have listed books for each certification...

Hi, I am using DB2 V8.1 on a linux system and I guess I have the appropriate fixpack. its a 32 bt system. I am trying to create a new partition on my system. So I changed the db2nodes.cfg file and also DB2COMM and DB2NODE reg variable. But when I issue a db2start command it gives an error...