DB2

db2 listener
Hi, I have problem to connect to db server from app server. The error is SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.59.72". Communication function detecting the er... 12 Jul 2006 19:35

SQL30081N
Hi, I have a remote DB2 database on AIX and I am accessing ti using a windows client .i was using control center on windows to add the remote system under it and I gave all the node names and pressed discover and it gives me the following error: ***************************************************************... 6 Jul 2006 11:47

clean up old log files
I have a question about DB2 ver 7.2 We are run out space and Network guys like to delete the old log files of db2 Last week we had a problem in developer because they deleted the old log files and DB2 was try to used it My question is what is the best way for clean up old log files thanks in advance ... 5 Jul 2006 15:15

Event ID: 7031
I'm wondering if anyone has had this issue in a Windows 2000 Server enviroment. "The DB2 - DB2 service terminated unexpectedly. It has done this one time(s)." Indeed, going back through the logs which span back to the machine inception, there has never been an instance of this occuring. There are no other er... 7 Jul 2006 08:54

No remote connections available
I have db2 EES installed on linux . db2level DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08025" with level identifier "03060106". Informational tokens are "DB2 v8.1.2.112", "s060429", "MI00155", and FixPak "12". Product is installed at "/opt/IBM/db2/V8.1". I have db2inst1 instance da... 27 Jun 2006 13:11

HADR
Hai everyone...... i was trying to implement the HADR concept ........ i tried using the following commands ...... On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1 HADR_REMOTE_HOST server_2 HADR_LOCAL_SVC port_s1 HADR_REM... 23 Jun 2006 09:05

Question on SUM()
I have the a hypothetical DB2 DETAIL table which includes the following columns: TRANS_TYPE, TRANS_AMT. All TRANS_AMTs are positive, but TRANS_TYPE of 1 indicates a credit (positive), and TRANS_TYPE 2 indicates a debit (negative). I want to write a query to return the net transaction amount for all transactions... 13 Jun 2006 11:35

I hope in Serge Rielau
Ciao a tutti ( Hi to all ) ( sorry for my bad english ) ! I have a problem with dynamic sql. I try to read all internet but I don't understand anything ! So I hope in Serge ( I love toronto in particular missaugua ) I write the error in my log file : " 2006.6.8 - 15:36.9 - [413] - INFO - --> Lo statment... 9 Jun 2006 10:58

translate function
Hi all, I am trying to remove all blank chars in middle of the string "text1 text2 text3 text3 text4" with following stmt: VALUES(translate('text1 text2 text3 text3 text4' , '' ,' ' )) But it seems that the resulting string same with the input string. 1 ----------------------------... 31 May 2006 12:24

PreparedStatement
Hallo zusammnen, ich möchte einen VARBINARY-Wert aus einer Tabelle auslesen, diesen in einer Datei speichern und später wieder in eine Tabelle einfügen. Den Wert hole ich mit einem Select und getString(). Das Ergebnis (z.B. 011b0148107f007310850069006e01671020205400550149) füge ich (nachdem ich es in einer Da... 6 Jun 2006 04:41