Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kaushik1979

  1. kaushik1979

    Monitoring DB2 Tables Spaces

    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...
  2. kaushik1979

    Export to a file with time stamp attached

    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
  3. kaushik1979

    Dropping all foreign keys

    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...
  4. kaushik1979

    Table Size

    Yes it does give the size in bytes
  5. kaushik1979

    Table Size

    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...
  6. kaushik1979

    DB2 Training Info Request

    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...
  7. kaushik1979

    Create Partition

    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...
See more

Part and Inventory Search

Back
Top