DB2
in [SQL]
|
How to reduce the highwatermark for a DMS tablespace? How to reduce the highwatermark for a DMS tablespace in V8.2? I have tried doing classic reorg on the table in the tablespace twice, but the highwatermark is lowered. Any ideas? ... 6 May 2008 22:20
Alter Table causes SQL0901N ( SQLSTATE=58004 ) Hi, I am trying to run the following SQL through the DB2 command line for version 9.1.0: alter table SCHEMA.TABLE1 drop column A; alter table SCHEMA.TABLE2 alter column B set data type decimal(15,4); * Column B was Integer. The commands both successfully return: DB20000I The SQL command complete... 7 May 2008 06:40
Date function in DB2 V8.1 for Z/OS Lennart wrote: On May 6, 10:56 pm, JAW <jwill...(a)aglresources.com> wrote: I need to get the first day of the previous month in a query. I thought CURRENT DATE and DAYOFMONTH would allow me to da it but it is noe WHERE DTXL >= 1st day of previous month Anyone got a good idea? I'm... 6 May 2008 21:27
What is the optimal average bufferpool read time in a multi partitioon datawarehouse? Hi, What would be the optimal/good/average/bad average bufferpool read times in a EEE data ware house environment? Also, is the operation of sending data over tablequeue will have affect because of high overall CPU I/O wait time? I was thinking it should not because communication is all dont at the memory leve... 24 Apr 2008 23:01
DB2 UDB Warehouse I am running DB2 UDB Workgroups V8.2 on Linux. I don't believe I installed the Data Warehouing capability when I installed. Is it difficult to enable that capability post installation?, and a second question is "Are the data warehousing capabilities available with my install limited, or are they full blown capabi... 24 Apr 2008 10:14
db2stop and db2start require password in partition env Hi! I'm trying to set up a database instance on a prime Linux server, using db2 V9.5 with fixpack 1 applied. I issued db2set DB2RSHCMD=/usr/bin/ssh After adding 2 partitions, when issuing db2stop (as instance owner), I have to give the password 6 times. When i the run db2start it suffices with 3 times. What... 24 Apr 2008 11:02
How do I turn 2 separate select queries into the columns of 1 select query Tonkuma wrote: If you have some columns to relate a planned row with a fabbed row, you can use them for join condition. If you have that column to join on, you can ignore the join altogether. For instance, if you have a WEEK column that you are reporting by, you could use: SELECT WEEK, SUM(case when myty... 23 Apr 2008 18:08
can a trigger do an execute immediate? I'm fairly new to DB2. I have been assigned to build a delete trigger that finds the data type of each of the table's fields so that the trigger can then build a string consisting of OLD values pre-wrapped in quote marks as needed. The deleted record's field values, all strung together as a single string, would... 24 Apr 2008 09:26
Sleep command in db2 Just want to know if there is a sleep command I could use to slow down the process in a stored procedure. I know people would've asked this question. I googled it, but everyone said that they haven't used in the stored procedures. I want to know if the sleep cannot be done directly in an SP, is there any workaround... 23 Apr 2008 15:44
Group privileges and views Hello, Quoting http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/ com.ibm.db2.luw.sql.ref.doc/doc/r0000935.html : Group privileges are not considered for any table or view specified in the CREATE VIEW statement. I discovered this today because a user complained that she couldn't create a simpl... 23 Apr 2008 15:44 |