Skip to Content
0
Former Member
Dec 04, 2007 at 05:21 PM

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

973 Views

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.