Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL error -904 accessing : [IBM][CLI Driver][DB2] DSNT408I SQLCODE = -904

Dear all,

we are importing a Basis queue from SAPKB620053 to SAPKB620063 but the importing job dead (RC 12) with the following reason:

Start import R3TRFUGRVSCAN_RFC ...

sap_dext called with msgnr 4:

db call info

function: db_docu

fcode: CI_WRITE_LINE

len: 68

key: FUVSCAN_RFC_INIT DT0002

ok fetches: 0

retcode: 4

SQL error -904 accessing : [IBM][CLI Driver][DB2] DSNT408I SQLCODE = -904, ER

RESOURCE 00000304, AND RESOURCE NAME SX40XAAA.DOKCLU .X'01815E' '.X'03'

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR

DSNT416I SQLERRD = 102 13172746 0 13813475 -1010298874 0 SQL DIAGNOSTIC INFORMATION

DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00D2C6E3' X'C3C81006' X'00000000' SQL DIAGNOSTIC

INFORMATION

Main import

End date and time : 20071204172624

Ended with return code: ===> 12 <===

*******************************************************

Kernel release 640

Compilation Linux GNU SLES-8

Patch Level 175

ABAP Load 1521

CUA load 16

Mode opt

Rsyn file

*******************************************************

Operating system: Linux Database system DB2/zOS

Machine type: s390x Release 8.1.5

*******************************************************

For note 875750, our DB2 version is 8 and in the note is reported the

following:

>> Mandatory: Your SAP system runs on DB2 V7. If it runs on DB2 V6 or

V8, this note does not apply!!!

For note 565490: we have checked the environment and update the

variables.

For note 355213: the parameters LOCKMAX = 1.000.000 and NUMKUSR =

2.097.152 (The maximum Value) >> The system parameter NUMLKTS sets the

default for the tablespace attribute LOCKMAX. . If the number of locks

on a particular tablespace exceeds the LOCKMAX value, these locks will

be replaced by a single tablespace-scope lock (note that the LOCKMAX is

enforced on a per thread, per tablespace basis).

We have the following parameters:

NUMKUSR = 2.097.152 (The maximum Value)

NUMLKTS= 10000

LOCKMAX = 1000000 for the TS

DSNT501I -DGQF DSNILMCL RESOURCE UNAVAILABLE 015

CORRELATION-ID=GQFGEN000

CONNECTION-ID=SERVER

LUW-ID=GA30243A.EB9D.071202215036=251705

REASON 00C90096

TYPE 00000304

NAME SX40XAAA.DOKCLU .X'01815D' '.X'17

Anybody can help me to go on with the import queue?

Kind Regards.

Former Member
Not what you were looking for? View more on this topic or Ask a question