DB2

UDF returning three scalars
Hello, I need to develop an UDF which return three scalar values. How can I group these three scalars together ? I've tried CREATE FUNCTION MYFUNC (P INT) RETURNS ROW (I1 INT, I2 INT, I3 INT) LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC .... RETURN VALUE... 16 Jun 2010 15:27

DB2 UDF Problem
Hi all, I am trying to implement UDF which will truncate 4 tables as part of UDF. The reason to choose DB2 UDF as apposed to DB2 Procedure is one of our Data Stage job uses this function as part of SELECT query. For example, if the datastage job wants to truncate any tables, it uses following query {code}SELE... 17 Jun 2010 04:36

Backup DB
Hi all, I have the following problem: Our customer X is using DB2 Express-C 9.5 on Windows Server 2003 (1 year of work without any problem) Switching to a new server (Windows Server 2008 - 64 bit), apparently db2 works correctly. When we do an offline backup (nightly backup) , db2 generates correctly the bac... 16 Jun 2010 01:16

Create Role as db2inst1 Gives Error SQL0552N
Hi Folks, New to DB2 but current Oracle DBA so please bear with me. System is RHAS 4u7 64-bit with DB2/LINUXX8664 9.5.1 This questions refers to a DB2 install for a Tivoli NetCool application. I have the following groups: dasadm1:x:102:db2inst1 db2iadm1:x:103: db2fadm1:x:104: itmuser:x:503: And the ... 15 Jun 2010 16:30

Create Role as db2inst1 Gives Error
Hi Folks, New to DB2 but current Oracle DBA so please bear with me. System is RHAS 4u7 64-bit with DB2/LINUXX8664 9.5.1 This questions refers to a DB2 install for a Tivoli NetCool application. I have the following groups: dasadm1:x:102:db2inst1 db2iadm1:x:103: db2fadm1:x:104: itmuser:x:503: And the ... 14 Jun 2010 16:13

Another question XML Output
Hi all, DB2 V9.5 FP5. In my XML query, I've a table multi valued like the following example: [db2inst1(a)JULIANA-PIRES ~]$ db2 "select * from T" ID MAC_ADDRESS ----------- ------------------------- 1 00:12:13:14:15:16 1 00:22:23:24:25:26 2 record(s) selected. Using th... 22 Jun 2010 22:38

Data Logistics of RFID
(CRN Magazine) Logistics is getting smarter thanks to data warehousing and business intelligence. When logistics systems run well they re like the umpire at a cricket match. We all know that they re around but we don t really notice them. But if they make a mistake then the spotlight shines brightly on their ever... 14 Jun 2010 09:30

Any gotchas for STMM
Folks, I wonder what the real-world results for turning STMM on, along with many of the AUTOMATIC memory config parameters that's been introduced since V9 ? We are turning STMM on in production. There's never enough traffic or volume of activities in development to get good estimates and find gotchas. Your expe... 25 Jun 2010 16:28

JDBC Interface for passign SQL Array type
I have a stored procedure that uses a user-defined data type that is an array of VARCHAR as its input parameter. Calling the SP from the CLP works fine: CALL MYPROC(ARRAY['abc,'def']) My question is how can this proc be called from within Java code? What Java data type is required and which methods can be... 17 Jun 2010 11:08

db2 hangs with diaglevel 4 on startup if log files are deleted
> > db2pd -stack -all hangs producing no output. Hmm, this should not happen either. Very odd. db2pd requires instance started: C:\IBM\SQLLIB\BIN>db2stop SQL1064N Zpracování pøíkazu DB2STOP probìhlo úspì¹nì. C:\IBM\SQLLIB\BIN>db2pd -stack all Unable to attach to database manager. Please ensure db2start has ... 16 Jun 2010 14:21