DB2

Stored Procedure performance issue - PLEASE HELP!
Hi All. I just trying to understand why a stored procedure call takes more time to response than an ODBC request. My company use JDEdwards with DB2 UDB database server. JDEdwards use ODBC technology to retrieve information from our DB2 server and I created an external application that consume the same data but v... 2 Feb 2010 14:37

Table partitioning i DB2 9.7 LUW
I am new to using table partitioning, but now we want to use it on a couple of tables. But when trying this we have experienced something I consider strange, when db2 doesn't act as i would expect. The environment is DB2 9.7 (fixpack 1) on Linux for z/OS (64-bits). We have created a table like this: CREATE TAB... 2 Feb 2010 14:37

Much RAM or fast RAM?
Hello, When sizing a new server, I can choose between 96GB of very fat RAM (1333MHz DDR3), or 128GB of slightly slower RAM (1066MHz DDR3). The server will be running DB2 v. 9.7 on Linux (64 bit). The amount of data will be around 10TB. The database will regularly be executing a lot of rather heavy GROUP BY o... 2 Feb 2010 14:37

Drawbacks of automatic storage?
Hello, I may be installing a new DB2 v. 9.7 Enterprise Edition (64 bit) on a Linux server soon. The database will contain around 10TB of data once it's fully loaded. We will not be using data compression (too expensive). We have previously used non-automatic (DMS) storage (and even raw devices, to a certain... 2 Feb 2010 14:37

Can Someone please help me with my Computer stuff? 08275
I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer Aspire AM5100-U5300A. I would like to speed this computer up, I would like a very good grasphics card without spending a fortune. Once I find out what I need I willo just go t... 27 Jan 2010 14:52

REplication of DB2 V9.7 tables with XML columns
Hi, I'm running Db2 V9.7FP1 64 bit on two Linux servers. I've got a number of databases living on the "primary" server that I'd like to replicate onto the "secondary" server. FWIW the primary box is redhat RHEL5.x and the secondary server is a Ubuntu VmWare image. I've been trying to use a the replication cen... 2 Feb 2010 14:37

function with input parameter not found (SQL0440N)
Hi, I am trying to create a function in db2 that takes in a parameter, and returns 1 value. I can make it work as long as there is no input parameter defined (see second part, func2). But for some reason, once there is an input parameter, I can no longer findthe function (error SQL0440N No authorized routine ... ... 25 Jan 2010 09:23

how to view a vertical table in horizontal way
Hello, I have a puzzle and hope there's an easy SQL solution (meaning no need to write a script). Firstly I'm on DB2 9.7 for AIX. I want to capture the current memory usage using the snapshot view: db2 "select SNAPSHOT_TIMESTAMP,POOL_ID,POOL_CUR_SIZE from SYSIBMADM.SNAPDB_MEMORY_POOL where pool_id in ('PAC... 20 Jan 2010 06:11

Fetching MAX rows with one index scan.
Hello, Db2 UDB v9.5 Fp3. I need to return the set of rows that have the highest timestamp. This is very easy: drop table DATA; create table DATA (sample timestamp, field1 integer); insert into DATA values ('2010-01-18-14.00.00.000000', 1), ('2010-01-18-14.00.00.000000',2), ('2010-01-18-14.00.00.000000'... 22 Jan 2010 20:49

SELECT INTO with ORDER BY and FETCH FIRST ONLY
Riddle me this, Batman... Take the following: EXEC SQL SELECT ACCOUNT_NUM INTO :GL-REF-ACCOUNT-NUM FROM FB_LN_ACCT_PROD_REF WHERE LOAN_TYPE =... 21 Jan 2010 12:17