DB2

Whitepaper - In-Memory Analytics
Yellowfin has released its latest Business Intelligence Whitepaper, this time on "In-memory Analytics" * No signup or email handover required, just click the link or cut/ past into your browser. http://yellowfin.com.au/Document.i4?DocumentId=104879 Feel free to give us any feedback Extract As the name ... 26 Apr 2010 06:55

DB2 V8.2 on Power7
Hi, I need to run an old DB2 V8-Database on Power7. Our Oracle-Team told me they needed special patches to run their O 11 on Power7. Am I going to face such difficulties with DB2 V8? I know, migrating to 9.7 would be best but this is currently no option on this specific database. By the way: How about 9.5 o... 27 Apr 2010 03:12

DB2 SQL0345N
Hi I have the following build problem with SQL executing the following. (Conversion MSSQL to DB2) The simplified code does the following(SQL0345N) DB2 Verson is DBUDB9.7(Fix1) WITH CTE_Tree(Seq1, Seq2,Type, TypeSeq, ItemSeq,CostType,Sort, Level) AS ( SELECT A.Seq1, A.Seq2, A.Type, A.T... 26 Apr 2010 03:41

Shutdown all instances
I have an AIX system with multiple versions of DB2 installed (v8.2, v9.1 and v9.7). Is there a way to find all active instances and shut them down regardless of the version? ... 23 Apr 2010 20:39

SQL4020N Resolution for IBM DB2 Version 9.1
Dear All, Currently we are using DB2 Version 9.1. We are trying to compile a embedded SQL C++ application but db2 precompiler ( prep ) throws this error "48 SQL4020N The 'long' host variable "*" is not valid. Use 'sqlint32' instead" so we overcame this error by passing 'LONGERROR NO' to db2 prep... 23 Apr 2010 20:38

Communication error - db2diag.log
The following is my environment: Solaris 10 SPARC DB2 V9.7 FP1 JDK ( 1.4.2_23-b01) SAP Netweaver 2004s (ABAP+JAVA Stack) Anyone here know what is the error message in db2diag.log file below mean? 2010-04-21-13.11.46.636334+120 I92733A429 LEVEL: Error PID : 2395 TID : 9 ... 23 Apr 2010 20:39

Filesystem configuration on HP UX for DB2
Good morning My question is about Filesystem configuration on HP UX for DB2. Is there any known "Best Practice" o special configuration for HP Filesystem (fstab) for running DB2 Server 9.5 on it? Environment: DB2UDB 9.5 FP4 ON HP UX 11.23a Thank you very much in advance. ... 23 Apr 2010 20:39

Yellowfin 5.0 release
Leading web-based BI provider, Yellowfin, will unveil their milestone 5.0 release in May 2010. This release includes significant enhancements; including an integrated in-memory database, that turbo charges analysis. Yellowfin 5.0 provides even greater insight, rapid deployment and requires minimal IT involvement. ... 23 Apr 2010 20:38

Multiple paths in references
Hi, don't know how to call this... It's not circular references, rather references where you have multiple paths between two tables, like this: A->C A->B B->D C->D or A->B B->C A->C etc. 1. How do you call this? 2. Is it bad design by default? 3. Is it bad design if your database is full of t... 25 Apr 2010 07:41

mssql to db convert questions?
DB2 SQL Table Function have a restriction that once a RETURN statement was executed, no control would be returned to the function(as you know). A way to avoid this restriction and to return multiple rows from a table function is to use a return statement with recursive common table expression. Here is a sam... 23 Apr 2010 20:38