DB2
in [SQL]
|
DBMS survey I am writing to sollicit your help in collecting data for a project at the Institute of Management of Tunis in Tunisia. We have derived a quantitative evolutionary model that attempts to capture the evolution of technology trends in software engineering by means of intrinsic attributes and environmental attributes... 19 Nov 2009 16:19
Help! weird Common Table Expressions behavior with SYSTEM TEMP TABLESPACE On Nov 13, 12:09 pm, Oleg Kozlovski <oleg...(a)googlemail.com> wrote: Hi all! I have a quite complicated query, which uses 4 or 5 common table expressions and produces about 155000 rows. But recently it started to consume the disc space at alarming rate. Investigations shows that it is due to the SYSTEM... 13 Nov 2009 08:46
Help! weird Common Table Expressions behavior with SYSTEM TEMP TABLESPACE Hi all! I have a quite complicated query, which uses 4 or 5 common table expressions and produces about 155000 rows. But recently it started to consume the disc space at alarming rate. Investigations shows that it is due to the SYSTEM TEMPORARY TABLESPACE with the page size 8K. Dropping this TS solves the proble... 13 Nov 2009 06:35
Doubts about CHECK CONSTRAINT Hello, could someone please explain why the following insert completes successfully? Tnx, Damir create table TEST1 (A char(1), B char(1)); alter table TEST1 add constraint CONSTR1 check ((A = 'D' and B is not null) or (A is null and B is null)); insert into TEST1 (B) values ('2'); ... 9 Nov 2009 06:37
reorgchk_ix_stats and reorgchk_tb_stats question Can anyone tell me for certain if these procedures use the current statistics or update statistics option on the reorgchk command? My testing seems to indicate it is using update statistics, but my test database is very small in volume, so I'm not sure. I see this question has been asked in the past, but I didn'... 6 Nov 2009 13:39
redirected restore from DMS/SMS to automatic storage is a redirected restore from DMS/SMS to automatic storage possible? I have created new db in v95 and want to take older db backup and restore tablespaces which were not automatic storage. How can I do it? TIA Suri ... 4 Nov 2009 18:37
Single System View (SSV) with DB2 9.7 DPF I have used the single system view with a backup on DB2 9.7 DPF. It allows one to backup all partitions without the db2_all command. Does this apply to the reorg command also (classic offline reorg)? If I issue a reorg from catalog node, does it reorg all partitions? ... 4 Nov 2009 09:40
New to DB2: problems with user management Hi, I just installed DB2 express and would like to authenticate a "regular" user on my machine, so that I don't have to use the admin user when querying the database. During installation one Windows user called "db2admin" was created. I can successfully log in to DB2 using that user (either through DataStudio o... 4 Nov 2009 06:23
Please help! set integrity using system tablespace 1. Why would set integrity use system temporary tablespace? 2. I created one system temp tablespace with 5 g on all nodes - and my table has table partitioning enabled ALONG WITH hash partitioning while the exception table is normal (but still hashed using the same keys), Still it is using the system temp tablespa... 9 Nov 2009 17:43 |