Topics
Replies
Author
Views
Last Post
SQL to get num_execs / rows read percentage 1 craig 23710 Fri Jan 03, 2014 4:19 amsuperman7
SQL to show how much space your tables are using 1 craig 17615 Thu Nov 28, 2013 8:46 pmdingdong
SQL to display snapshot data collected in dba tables. 2 craig 19385 Mon Jul 29, 2013 10:53 pmJamez99
Recursive SQL split column data into rows 0 craig 21288 Tue Jun 15, 2010 6:25 amcraig
DBI1167E DPF instance cannot be updated from non instance 0 craig 17958 Sun May 16, 2010 11:27 amcraig
sql to return tablespace names, nodegroup, pgsz, totalpages 0 craig 17988 Fri Sep 11, 2009 12:19 pmcraig
create snapshot tables ddl 0 craig 17573 Thu Feb 12, 2009 11:18 amcraig
recover dropped table 0 craig 16571 Thu Dec 11, 2008 7:43 amcraig
reduce tablespace - reclaim space - reset high water mark. 0 craig 16407 Wed Jul 09, 2008 4:12 pmcraig
sql for stored proc to copy big tables 0 craig 16648 Wed Nov 29, 2006 2:29 pmcraig
script to create alter tablespace stment with add containers 0 craig 17526 Thu Nov 02, 2006 3:33 pmcraig
sql to snapshot tablespace percent free space < 20% 0 craig 16856 Mon Oct 23, 2006 3:36 pmcraig
gen create tablespace statement, distribute across spindles 0 craig 16243 Mon Oct 23, 2006 1:52 pmcraig
default database configuration settings 0 craig 15977 Fri Oct 20, 2006 7:41 amcraig
db2 on linux settings for IO tuning. 0 craig 16179 Thu Sep 28, 2006 2:08 pmcraig
sql to assign row numbers to rows returned by select 0 craig 16420 Thu Sep 28, 2006 9:43 amcraig
sql to generate sql to drop foreign keys 0 craig 16886 Thu Sep 07, 2006 1:58 pmcraig
sql to select tablename with tbspaceid, tableid, colno 0 craig 16613 Sat Aug 19, 2006 9:41 amcraig
select table statistics 0 craig 16184 Wed Aug 02, 2006 7:17 amcraig
select rows in table a that are not in table b 0 craig 16322 Tue Jul 25, 2006 6:31 amcraig
space used by index tablespaces (1st try) 0 craig 21219 Fri Jun 23, 2006 2:01 pmcraig
script to replicate tables accross databases 0 craig 16225 Fri Jun 16, 2006 7:22 amcraig
sql to generate sql to create aliases 0 craig 15797 Thu Jun 15, 2006 9:13 amcraig
DB2 instance on high speed dasd 0 craig 15790 Wed Jun 14, 2006 7:58 amcraig
Script to send attachment in email. 0 craig 15604 Thu May 25, 2006 8:02 amcraig
ddl to restore and rollforward tablespaces online. 0 craig 15596 Tue May 23, 2006 12:42 pmcraig
Java snippit to use blob data types 0 craig 13847 Tue Feb 28, 2006 3:36 pmcraig
SQL for identity column sequence number reset. 0 craig 13750 Tue Feb 28, 2006 2:23 pmcraig
SQL to return a row as xml 0 craig 13171 Tue Feb 28, 2006 7:04 amcraig
Script to save snapshot data into DBA schema. 0 craig 12579 Tue Feb 28, 2006 6:44 amcraig
SQL Statements to list dependencies of objects. 0 craig 14235 Tue Feb 28, 2006 6:39 amcraig
Shell script to generate SQL to extend tablespaces to 20% 0 craig 11922 Tue Feb 28, 2006 6:38 amcraig
Display topics from previous: All Topics 1 Day 7 Days 2 Weeks 1 Month 3 Months 6 Months 1 Year
Album
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
![New posts [ Popular ]](templates/subSilver/images/folder_new_hot.gif){kind=small}
![No new posts [ Popular ]](templates/subSilver/images/folder_hot.gif){kind=small}
![New posts [ Locked ]](templates/subSilver/images/folder_lock_new.gif){kind=small}
![No new posts [ Locked ]](templates/subSilver/images/folder_lock.gif){kind=small}