Database Forum - DB2 Topics

Thread preview

Thread	Last Post	Replies

Maximun number of schema per Db	23 May 2007 17:05 GMT	2
What is the limitation for the number of schema per database, how many schema we can have for a database. Thanks situ
MDC vs optimizer	23 May 2007 16:39 GMT	1
DB2 V8 FP10 We are doing some performance tunning with an MDC table and we found unexpected access plans with columns used for range and IN predicates (Optimization class 7).
how to select a table that has most columns using syscat?	23 May 2007 15:56 GMT	10
how to select a table that has a highest amount of columns (compared to other tables) using syscat? thanks in advance
Do calculation in Char filed	23 May 2007 15:25 GMT	7
is there any way, can we work around with mathematical calculation in char filed, like if i am storing '3+5' in character field, can make a calculation on the above field and get the values 8 . thanks and regards
[question] db2 v8, how to force applications which status in "Federated request pending"	23 May 2007 02:18 GMT	2
env: db2 LUW v8 + aix We encounter some java applications status did not change and keep in "Federated request pending" for a long time. we try issue db2 "force applications <handle id>" to terminate the
SQL compiler and buffer pool	22 May 2007 20:28 GMT	3
I have a database DB2 v8.1.1.112 on AIX 5.2 With the following BP. select BUFFERPOOLID, NPAGES,PAGESIZE from syscat.bufferpools BPNAME NPAGES PAGESIZE
Command to bind all the packages	22 May 2007 19:49 GMT	2
Hi ! All, Question on binding packages on UDB 8.x on AIX 5.x... Is there is way to bind all the packages like a BIND ALL? Thanks
Migrating from DB2 on z/OS	22 May 2007 07:55 GMT	3
I am looking into migrating a database from DB2 on z/OS to Oracle on Windows. I am quite new to databases and would appeciate any information on free programs that do this or a good process for carrying this out.
9.1 Problem changing logging to circular	21 May 2007 22:59 GMT	2
On a 64 bit linux, db2 9.1 system, I am trying to change logging to "circular" via: ----- UPDATE DB CFG FOR MYDB7 USING logarchmeth1 OFF logarchmeth2 OFF
case insensitive ??	21 May 2007 21:52 GMT	2
Hallo!! Is it possible to set database (db2 v8) to be case insensitive?? Signature Regards, Wojtas
Share nothing cluster architecture	21 May 2007 20:31 GMT	1
Can anyone refer me to the db2's Share nothing cluster architecture document ? I'm interested in a tecnical document describing how a query is parsed and executed in this environment.
JOB POSTING: Looking for a senior database manager /department head/ architecture	21 May 2007 14:56 GMT	3
Please have a look: http://www.occ.treas.gov/jobs/DEU-HQ-07-073.htm
SQL4401C The DB2 Administration Server encountered an error during startup	21 May 2007 08:55 GMT	3
I have a problem to startup de DB2 Admin. I read meny documentation in internet and nothing work, anybody know something??. I have DB2 UDB V8 fixpack 14 and AIX 5.2 x134[/u/db2as] db2admin start
OS X and DB2	19 May 2007 22:46 GMT	1
I'd like to connect to a remote machine running DB2 8.1 using Perl from a machine running OS X. That is, using the Perl modules DBI and DBD. Is this possible?
Database connection through SP	18 May 2007 19:38 GMT	8
i have Database1 and database2, is it possible to make database connection to database2 by running stored procedure on database1. Thanks and Regards