CLI0108E Communication link failure

[Wolfgang B.]

Hi.

I am using a perl-script to sync data between databases using perl.
This script runs every 30 seconds for about 6 days without any
problems. After restarting the database, everything works fine for
another 6 days.

Environment:
Redhat 7.3
Perl 5.6.1
DB21085I Instance "db2ipoi" uses DB2 code release "SQL07024" with
level
identifier "03050105" and informational tokens "DB2 v7.1.0.60",
"s020313" and
"U481413".

The error on the client is:
DBD::DB2::st fetchrow_array failed: [IBM][CLI Driver] CLI0108E
Communication link failure. SQLSTATE=40003 at
/home/poi/bin/sync-database2.pl line 571.

db2diag.log contains:
(The table mbt_feedback_at x_rem is a nickname for a table on a remote
database server on a different machine.)

2005-01-04-18.00.51.779149 Instance:tmatic Node:000
PID:14407(db2ag ent (TPDBEUB)) Appid:AC156427. E5B4.0501041700 51
lob_manager sqldx_lob_read Probe:3 Database:TPDBEU B
Message is unavailable.
2005-01-04-18.00.51.782661 Instance:tmatic Node:000
PID:14407(db2ag ent (TPDBEUB)) Appid:AC156427. E5B4.0501041700 51
relation_data_s erv sqlrl_sysTables GetConst Probe:20
Database:TPDBEU B
Message is unavailable.
2005-01-11-15.30.52.657217 Instance:tmatic Node:000
PID:14407(db2ag ent (TPDBEUB)) Appid:AC156427. C7BF.0501111430 52
global_services sqlzerdm Probe:40 Database:TPDBEU B

00d6 ffff .Öÿÿ


2005-01-11-15.30.52.692282 Instance:tmatic Node:000
PID:14407(db2ag ent (TPDBEUB)) Appid:AC156427. C7BF.0501111430 52
relation_data_s erv sqlrr_signal_ha ndler Probe:10 Database:TPDBEU B
Message is unavailable.Dum p
File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:Recursive
dump_sect
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:PACKAGE
ENTRY
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:USED_IN_UO W
BIT VECTOR
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:SECTION
NUMBER
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:SECTION DIR
ENTRY
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:cursor name
Dump File:/home/data/tmatic/sqllib/db2dump/14407.000 Data:cache cb

Data Title:section stmt PID:14407 Node:000
5345 4c45 4354 206d 6178 286a 756c 6961 SELECT max(julia
6e5f 6461 7928 4352 4541 5445 4441 5445 n_day(CREATEDAT E
2920 2b20 6d69 646e 6967 6874 5f73 6563 ) + midnight_sec
6f6e 6473 2843 5245 4154 4544 4154 4529 onds(CREATEDATE )
2f63 6173 7428 3836 3430 3020 6173 2064 /cast(86400 as d
6f75 626c 6529 292c 6d61 7828 4352 4541 ouble)),max(CRE A
5445 4441 5445 292c 636f 756e 7428 2a29 TEDATE),count(* )
2046 524f 4d20 4d42 545f 4645 4544 4241 FROM MBT_FEEDBA
434b 5f41 5458 5f52 454d 2077 6974 6820 CK_ATX_REM with
7572 ur

....

Does someone has a idea what the problem could be. The same script is
used for other databases on different instances and it works fine
there.



Regards

Wolfgang