dbrtab error in SpTSP02Insert

[Former Member]

hi experts,

am facing problem in spool. Our QA system has some spool dumps " SPOOL_I/O_ERROR". ITs detailed description :An I/O error occurred when calling the SAP spool system.

More detailed description of error: "dbrtab error in SpTSP02Insert "

look at Spool Error Information

-

---

============----

---

RSPO - Error

code: 8 RSPOEIO Some I/O error.

dbrtab error in SpTSP02Insert

module: rspodb02 no: 1 line: 296 T100: PO004

TSL01: F7M p3: 1

p4:

-

---

No entry in error history

-

---

Error propagation from: primary key table access (RTAB)

RTAB error 1

-

---

Some SQL information, which may or may not belong to this error:

SQL error code -7008

TSP02 in R3TQADATA not valid for operation. MSGID=CPFB755 Job=126360

I have already deleted old spools , I had also performed consistency check, But still i face the same problem

Can someone help to solve this issue.

best regards

Tamer

[Former Member · Accepted solution]

Dear Ben ,

I checked with sm12 & there is no old or dead locks ,only current working users locks

pls. check also the following two errors in sm21:

1)TSP02 in R3TQADATA not valid for operation. MSGID=CPFB755

2)Spool: RT_INSERT Reports Error 1 for Table

The RTAB interace has reported an unexpected error return code to the

spool. The RTAB function used was 'RT_INSERT'. The error number used in

the message can be translated using 'dbrtab.h' and 'dbglobal.h'.

regards

Tamer

[former_member186143 · Accepted solution]

hmmm is there a solution for this problem already ??

I suffer the same troubles over here

[Former Member]

Hello Tamer

in DB2 for LUW

SQL7008N REXX variable variable contains inconsistent data.

so thats most probably not the case .

Seems to be more OS/400 issue

see SAP Note

116192 AS/400: SQL error -7008

which looks very similar to your issue .

Best regards

dirk

[Former Member]

hi ben

tks. for your reply , we checked spaces and liberaries and nothing strange

do u have any other suggestion?

regards

[Former Member]

Hi,

check transactions SM12

Regards

Ben

[Former Member]

Hi,

Please check space OS level file system

Regards

Ben

[thomas_vogt]

Moving to DB6 forum since this seems to be DB2 LUW.

Regards,

Thomas