IBM DB2

Richard wrote: To be precise: SQL Reference states: SQL comments Static SQL statements can include host language or SQL comments. Dynamic more »

Still Error 404: SRVE0190E: File not found: /web/reg/www.ibm.com/developerworks ... More than 24 hours without a file that DeveloperWorks mail... more »

pwu@qantas.com.au wrote: The way as defined by IBM: /usr/local/bin/db2ls -c This will give you an output that should be relatively easily parsed... more »

On Oct 9, 11:05 am, w.l.fisc...@googlemail.com wrote: I'm not entirely familiar with the details, but at our site we have all instance owner users... more »

DB2 9.5 provides global variables: CREATE VARIABLE X INTEGER; and SET x = <some expression>; To get them out from a client you can use: SET ? = x; (I... more »

SQL0104N An unexpected token "DROP FUNCTION" was found following Well the parser is absolutely right here. DROP FUNCTION is not supported in inline... more »

I’m trying to set up DDF on DB2 9.1 and am getting the following error – DSNL013I -DB9G VTAM OPEN ACB FAILED ERROR='24'X SNA Programming explains... more »

Great, thanks. Best regards, Kovi Lennart pravi: -- ____________________________ |http://kovica.blogspot.com| more »

"Jack" <jacquestardif@gmail.comwrote in message news:3b4b3050-0836-4ee1-9958-ac0382cfb043@i20g2000prf.googlegroups.com... Generally speaking, the... more »

Hi listers , Has anyone met REORG INPLACE error -964 " The transaction log for the database is full " ? I wonder , why REORG INPLACE error... more »

Richard wrote: Run 'db2level' from within the client instance environment. See the version 8 (or 9) documentation. See the version 8 (or 9)... more »

Hi Listers , While REORG INPLACE WRITE ACCESS , large and frequently update table , previous' DBA got experience that all the program could not... more »

Thanks for your reply. I have found the solution after some research. It's similar to Lennart's solution. On Oct 8, 12:37 pm, --CELKO--... more »

Justin wrote: No, you have to use a column in the physical table. more »

Note that your under Windows at DB2 V9.5 At that level with that OS the INSTANCE_MEMORY parm. of your dbm cfg is critical. The instance manages all... more »

On Oct 7, 1:51 pm, w.l.fisc...@googlemail.com wrote: I found something now... Unfortunately, it's a bit hidden (I remember, I needed some time to... more »

As part of my thesis for my MSc Course with the Open University UK, I need to collect various performance statics for IBM's DB2 database... more »

Dave Hughes wrote: I had been confidently looking for something built-in, but I guess I was assuming it would have a more obvious name. Anyway,... more »

Diego de la Vega wrote: If you do an offline backup of the database, then you don't need to copy anything else. If you do an online backup, you may... more »

On Oct 3, 8:38 am, Justin <kfw...@hotmail.comwrote: CREATE PROCEDURE RET_TEST() LANGUAGE SQL SPECIFIC ARCHIVE_RET_TEST INHERIT SPECIAL... more »

This is an example db2 -td; RESTORE DATABASE SAMPLE FROM "C:\Program Files\IBM\SQLLIB\BIN" TAKEN AT 20070622115322 TO "C:" INTO... more »

On Oct 2, 8:47 am, "Henry J." <tank209...@yahoo.comwrote: CELKO has a good discussion about the logic behind what is going on. However, if you look... more »

On 3 Okt, 14:42, "lenygold via DBMonster.com" <u41482@uwewrote: Not sure what you find confusing, but I think it will become clear to you if you... more »

We found an mid-range app that is running 400 times a second up to the mainframe and getting a +100 every time (nice) so we will be meeting with... more »

The IT folks did an automatic upgrade of DB2 connect to V9 our our Windows machines, and now when we try to use DB2 on z/OS from an Eclipse plugin... more »