Federation and EEE 7.2 Fixpak 7 under AIX

Mark Horrocks

Federation and EEE 7.2 Fixpak 7 under AIX

Has anybody encoutered the following error when inserting into local
table when selecting from a federated table.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Ins".) SQLSTATE=58004

The db2diag.log shows,

DIA9999E An internal error occurred. Report the following error code :

Data Title:SQLCA PID:2834652 Node:001
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 3
sqlerrmc: Ins
sqlerrp : sqlnFAKE
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)

Many Thanks.

Tired of spam? Get advanced junk mail protection with MSN 8.