IBM Support

SQL30090N with reason code 1 or 7 returned by the application against DB2 database server

Troubleshooting


Problem

How to resolve SQL30090N RC 1 (against read only database) or 7 (while accessing a second database with CONNECT statement of type 2 CONNECT) returned by the application against DB2 database server?

Symptom

Reason code 1:

Corresponding entries from DB2 database server db2diag.log:


2012-03-19-14.19.46.016044-240 E5516441G607 LEVEL: Warning

PID : 3489 TID : 2933910384 PROC : db2sysc

INSTANCE: db2inst1 NODE : 000

APPHDL : 0-1649

EDUID : 1201 EDUNAME: db2agent ()

FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseMgrLvls, probe:10

DATA #1 : String, 266 bytes

Unable to generate SYNCLOG information required for resynchronization.

TWOPHASE support disabled. To enable support startup the DB2 TCPIP

Listener, by setting the DB2COMM registry value to TCPIP and

configuring the DBM configuration parameter SVCENAME.

2012-03-19-14.19.46.143944-240 I5517049G526 LEVEL: Error

PID : 3489 TID : 2933910384 PROC : db2sysc

INSTANCE: db2inst1 NODE : 000 DB : ABCD

APPHDL : 0-1649 APPID: *LOCAL.db2inst1.xxxxx

AUTHID : PS

EDUID : 1201 EDUNAME: db2agent (ABCD)

FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:1610

MESSAGE : ZRC=0x80100149=-2146434743=SQLP_APP_READ_ONLY

"Read only application trying to write log record"

Reason code 7:

2013-11-08-17.57.32.916479-360 E4801175A632 LEVEL: Warning
PID : 15794194 TID : 8835 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-3846
HOSTNAME: test
EDUID : 8835 EDUNAME: db2agent () 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseMgrLvls, probe:10
DATA #1 : String, 266 bytes
Unable to generate SYNCLOG information required for resynchronization.
TWOPHASE support disabled. To enable support startup the DB2 TCPIP
Listener, by setting the DB2COMM registry value to TCPIP and
configuring the DBM configuration parameter SVCENAME.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Connectivity - TCP\/IP Protocol","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg21589095

Page Feedback