DB2

SQL stored procs
we are still running version 8.3 UDB for LUW. We are planning to upgrade to 9.5 shortly. I am needing to send email and possible put some data on MQ from a SQL PL stored proc.. I see where in 9.7 they have system procs to do some of this, but is there a way to do this using 8.3 or maybe 9.5..... ... 3 Sep 2009 07:19

Rounding error
What's going on here: select (11/5) as test from sysibm.sysdummy1 test == 2 I'm seeing my calculations round down to the nearest 1. I don't want that... ... 3 Sep 2009 07:19

Db2 going down frequently
Hi Everybody, Here is the desc. of our environment. DB2: v8.1 fp17 to v9.5 fp 3a OS: Win 2003 Server SP 1 RAM: 3.5 GB HDD: 80GB DB size 7.5 GB 1. Since days, we hve been getting a strange warning message in the event viewer logs: The description for Event ID ( 1 ) in Source ( DB2REMOTECMD_DB2COPY1 ) cannot be... 3 Sep 2009 07:19

Regarding database Size
Hi, on one of my dev server is giving following error when i am trying to get the db size db2 'call get_dbsize_info(?,?,?,1)' SQL0443N Routine "*IZE_INFO" (specific name "") has returned an error SQLSTATE with diagnostic text "SQL0444 Reason code or token: *TAMPDIFF, SQL020422182517115". SQLSTATE=38553 ... 19 Dec 2008 17:56

License problems (and coredump) after Fixpack
Greetings! I have DB2 SDK 8.2.9 on AIX 5300-08. I have just installed FixPack 17. The server has been rebooted. Now when I try to connect, I get this error: SQL8002N Connect processing failed; a valid product license was not found. If I do 'db2licm -l' I get a bunch of binary gibberish and then it ... 5 Dec 2008 18:13

DIA8519C A file sharing violation has occurred, filename was ""
Hi everyone , I get the below message in one my database server's diaglog . Any idea what could be the reason? It doesnt give me the filename even. It says filename was "" . 2008-12-01-01.08.29.704961-360 I13454563E483 LEVEL: Severe PID : 8895 TID : 183031718752PROC : db2agent (XM... 11 Dec 2008 01:06

Instance migrated to v9.5 / STMM and bufferpools
> What fixpack do you have? On DB2 Express-C for 64-bit Linux FP0 (FP2 is now available) I had to hardcode all bufferpools to keep it from crashing. I still have them hardcoded, because I don't see how DB2 can properly tune bufferpools if you have more than one bufferpool (and if there is a good reason f... 11 Dec 2008 12:27

Client Password Validation Error
I have a client application which runs on a Linux server which is intermittently unable to connect to my database. This application is a daemon which sits on the server and waits for a request, it then connects to the database writes some data and disconnects. 99.99% of the time this works great, but sometimes it... 2 Dec 2008 19:39

System Time and Utilities Start/Stop Time
I notice that there is a difference between the system time and the start/stop time of utilities. For example, in the db2diag file entry below, the diaglog entry time shows 4 mins more than the load start time. 2008-11-26-12.24.04.365000+240 I588034H480 LEVEL: Warning PID : 4196 TID... 26 Nov 2008 04:48

How do I concatenate strings from a column into a single row in DB2
How do I concatenate strings from a column into a single row? Whats the logic to create the function in DB2. Given is below. Color ------ red orange blue green And return a resultset like this: Colors ------------------------- red,orange,blue,green ... 24 Nov 2008 16:44