|
Timestamps on data records, Documentation on old versions ofDB2 Dave Hughes wrote: Ion Freeman wrote: Hi! My database work has been largely with SQL Server, PostgreSQL and Oracle, so when I have a DB2 question, I don't really know where to turn. I could find the documentation for the current version of DB2 on IBM's website, but I don't know if what's t... 3 Jul 2008 13:32
DB2 8.2 Workgroup Server Edition limitattions DB2 8.2 Workgroup Server Edition is supposed to be limited to servers with 4 CPU's and 16 GB of memory. It can be licensed by user, or by number of CPU's. Are these limitations hard or soft? In other words, if the server with WSE 8.2 has more the 4 CPU's, will DB2 use them? If the server has more than 16 GB ... 5 Jul 2008 10:28
SQL0101N The statement is too long or too complex. SQLSTATE=54001 Eric Davidson wrote: DB2 9.5 I keep geting the message. SQL0101N The statement is too long or too complex. SQLSTATE=54001 When one of my sql statements takes over 60 seconds to compile the sql statement. Is there any parameter that controls how long DB2 allows a statement to compile... 3 Jul 2008 10:26
SQL0101N The statement is too long or too complex. SQLSTATE=54001 DB2 9.5 I keep geting the message. SQL0101N The statement is too long or too complex. SQLSTATE=54001 When one of my sql statements takes over 60 seconds to compile the sql statement. Is there any parameter that controls how long DB2 allows a statement to compile for. I have increased the statement heap... 3 Jul 2008 10:26
Timestamps on data records, Documentation on old versions of DB2 Hi! My database work has been largely with SQL Server, PostgreSQL and Oracle, so when I have a DB2 question, I don't really know where to turn. I could find the documentation for the current version of DB2 on IBM's website, but I don't know if what's true for the current version is true for the version my clien... 2 Jul 2008 21:10
privileges on functions I created one function and wish to assign it to some users. however, even though "grant execute on function" succceeded, that user can still not use it. i am wondering if functions do not have transferable rights? i am using v9.1. thanks ... 3 Jul 2008 09:24
Find a sentence with words separated by multiple spaces Hi everyone, I am trying to find an efficient way to perform a special query. Let me explain what I want. Let's say we are looking for all description that match "this is the target". In fact, I want to find records that match those 4 words in this sequence disregarding the number of spaces (I mean spaces, t... 2 Jul 2008 16:01
library compatibility libdb2.so undefined reference to `__cxa_guard_acquire@CXXABI_1.2.1' When creating an executible received this error during the linking... g++32 -L/usr/lib/x86_64-redhat-linux3E/lib64 -o confusion cdb.o conindb.o confusdb.o confusion.o ../../arc/lib/arc.a ../shared/lib/ database.a -Wl,-rpath,/home/userid/sqllib/lib -L/home/userid/sqllib/ lib -ldb2 -lpthread /home/userid/sqllib... 2 Jul 2008 12:55
Yellowfin Business Intelligence Release 4.0 Announced to Industry (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst most of the activity in the BI space has been busy with merger and acquisitions, Yellowfin has continued focussing its efforts to develop web Business Intelligence soft... 2 Jul 2008 07:47
Temp tablespace - system or user? I have a sql that goes like select ............... from table (select ....... from table t where <>) as x Now this temp table x is supposed to keep 10 K rows at a point of time. Where would they be stored? I know the answer is temp tablespace, but is it in system temp or user temp? All I am trying to do is to... 2 Jul 2008 10:51
TRANSLATE function Hi, Does anybody know why i get this error: SQL0176N The second, third or fourth argument of the TRANSLATE scalar function is incorrect. SQLSTATE=42815 with this query: SELECT TRANSLATE(p.meno, 'aaaaccdeeeiillnnoooorrsstuuuuyzzAAAACCDEEEIILLNNOOOORRSSTUUUUYZZ', 'áâãäæèïéìëíîåµñòóôöõàø¶¹»úüûùý¼¾ÁÂÃÄÆÈÏÉÌËÍÎÅ¥... 1 Jul 2008 17:29
SMS TableSpace - Reorg not releasing space. Running DB2 9.1 on Redhat Linux 4.1. Storage management indicates that the pages stored in a file based SMS container occupy 7 gig of the total space allocated which is 50gig. I wrote a script to reorg and runstat all the tables in the tablespace but the reorgs are not releasing space to the file system. Is t... 1 Jul 2008 00:02 |