Please try the following:
CREATE REGULAR TABLESPACE MYTBSP PAGESIZE 16 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL MYDEFBPOOL DROPPED TABLE RECOVERY ON;
CREATE TABLE TAB1 (...........) IN MYTBSP
This most of the time improves ur performance
niladri123
Last Activity: Jul 7 '08, 11:02 AM
Joined: Dec 11 '07
Location:
-
please read the following details [from the manual]
db2top can be run in replay mode, which means it can be
run against a saved copy of the raw binary snapshot data.
In order to do so, db2top must be run first in data collector
mode, either in batch mode by running db2top from
the command line with the [−C] switch, or by activating/
deactivating data collection from an interactive session...Leave a comment:
-
u can try
create distinct type date1 as integer with comparisons
tab2 col1 (date1)
select * from tab1 inner join tab2 on tab1.date1(col1 ) = tab2.col1Leave a comment:
-
please follow the following steps
1. Connect to a database
2. Force application all / (If not working db2_kill)
3. db2stop
4. db2admin stop
5. db2admin start
6. db2admin start
Now create the database.Leave a comment:
-
select date(19-1-08) from sysibm.sysdummy 1Leave a comment:
-
I think u can ask in oracle forum....
By mistake u have putted in db2Leave a comment:
-
check with !db2 ? sql0443 (if u havent)
Also please tell me if this one is a non fenced query or not ?Leave a comment:
-
please set userexit = ON for the same database.Leave a comment:
No activity results to display
Leave a comment: