SQL error "-99999" occurred when accessing program

[supriya_karale]

Hello experts ,

I am getting following dump while moving data from R/3 system to BW system                                                                                                                                                                                                                        DB2 9.1.0.8

           Please provide appropriate solution urgent.

[Former Member]

Hi supriya,

This dump occurs when there is Table space issue. This mostly occurs when the table size is less or the data file size is increased. Just try increasing the table space ( add the datafile) might solve this issue.

[former_member182657]

Hi Supriya,

Database error: TemSe->RTAB-S/G(8)->4 for table TCPSBUILD key

Suggest you to follow SAP Note 864267 - Code page conversion error after WP has left reconnect state

During the period, when the work process is in reconnect status, many syslog entries of the kind

SYSLOG : F6H Database error: TemSe->RTAB-S/G(8)->1 for table TCPSBUILD

and try to patch the kernel with latest available at SMP.If issue still persists share the complete dump details.

Regards,

[supriya_karale]

Hello,

Please check sm21  details and db2diag.logs

------------------------------------------------------------------------------------------------------

|Time    |Type|Nr |Clt|User|TCode|Grp|N|Text                                                         |

------------------------------------------------------------------------------------------------------

|04:00:06|DIA |001|   |    |     |F6 |H|Database error: TemSe->RTAB-S/G(8)->4 for table TCPSBUILD key|

------------------------------------------------------------------------------------------------------

Database error: TemSe->RTAB-S/G(8)->4 for table TCPSBUILD key

Details

Recording at local and central time........................ 11.01.2016 04:00:06

----------------------------------------------------------------------------------------------------------------

|Task......|Process                    |User......|Terminal|Session|TCode|Program|Cl|Problem cl        |Package|

----------------------------------------------------------------------------------------------------------------

|05572     |Dialog work process No. 001|          |bcinicoe|      1|     |       |K |SAP Web AS Problem|STMS   |

----------------------------------------------------------------------------------------------------------------

Further details for this message type

-------------------------------------------------------------

|Module nam|Loc|Error text..........                        |

-------------------------------------------------------------

|rscpgdio  | 15|RTAB-S/G&8&4&TCPSBUILD                     &|

-------------------------------------------------------------

------------------------------------------------------------------

|Documentation for system log message F6 H :                     |

|                                                                |

|Database error:  TemSe->&A(&B)->&C for table &D key &a          |

|                         !  !    !            !                 |

|                         !  !    !            Table name        |

|                         !  !    Error number                   |

|                         !  Function number                     |

|                         Database access module                 |

|Possible database access modules                                |

|RTAB                                                            |

|Direct access with entire or partial primary key                |

|XRTAB                                                           |

|direct access with entire or partial primary key for all clients|

|INCLUDE 'RSTS_RTAB_FUNCTIONS' OBJECT DOKU ID TX                 |

|INCLUDE 'RSTS_RTAB_ERRORS' OBJECT DOKU ID TX                    |

|INCLUDE 'RSTS_TABLES' OBJECT DOKU ID TX                         |

------------------------------------------------------------------

Technical details

-------------------------------------------------------------------------------------------------------------------

|File|Offset|RecFm|System log type         |Grp|N|variable message data                                           |

-------------------------------------------------------------------------------------------------------------------

| 180|206280|k    |Error (Module, Location)|F6 |H|RTAB-S/G&8&4&TCPSBUILD                     &         rscpgdio 15|

-------------------------------------------------------------------------------------------------------------------

DB2DIAG.LOG

PID     : 14198                TID  : 47596010571792PROC : db2syscr

INSTANCE: db2oep               NODE : 000

FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1

START   : DB2 DBM

DATA #1 : Build Level, 152 bytes

Instance "db2oep" uses "64" bits and DB2 code release "SQL09018"

with level identifier "02090107".

Informational tokens are "DB2 v9.1.0.8", "special_23085", "MI00278_23085", Fix Pack "8".

DATA #2 : System Info, 440 bytes

System: Linux bcinicoep001 6 2 x86_64

CPU: total:3 online:3 Cores per socket:1 Threading degree per core:1

Physical Memory(MB): total:31189 free:30168

Virtual  Memory(MB): total:80349 free:79328

Swap     Memory(MB): total:49160 free:49160

Kernel   Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024

                 msgNumberOfHeaders:65536 msgMaxQueueSize:65536

                 msgMaxSegmentSize:16 shmMax:23136829430 shmMin:1 shmIDs:4096

                 shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000

                 semUndo:256000 semNumPerID:1250 semOps:100 semUndoSize:20

                 semMaxVal:32767 semAdjustOnExit:32767

Cur cpu time limit (seconds)  = 0xFFFFFFFF

Cur file size limit (bytes) = 0xFFFFFFFF

Cur data size (bytes)  = 0xFFFFFFFF

Cur stack size (bytes)  = 0x00A00000

Cur core size (bytes)  = 0x00000000

Cur memory size (bytes) = 0xFFFFFFFF

nofiles (descriptors)  = 0x00008020

[Sriram2009]

Hi Supriya.

Could you check the consistence check of Spool DB using transaction code SPAD

Regards

SS

[supriya_karale]

hello ,

Consistency check is ok in SPAD.

Should I check anything else??

[Former Member]

Hi Supriya,

Paste the complete dump. Check SM21

The dump may be because of

The db2 agent running was terminated due to a deadlock, sec log full or network issue.

Check db2diag.log file for the mentioned time frame and check if you find something.

Regards,

Prithviraj.

[supriya_karale]

Hi prithviraj,

I have attached complete dump as well as db2diag.log file .

please check and suggest.

I have checked the system it didnot terminated due to deadlock or sec log full.

please check and suggest.

[Sriram2009]

Hi Supriya.

Where is the log attachment?

Regards

SS

[supriya_karale]

Hello Prithviraj ,

Please go through logs and suggest the solution urgently.

[Former Member]

Hi Supriya,

The logs provided are not relevant.

Please supply the logs that were reported at the time of error/dump.

dev_w log, ST22 complete dump and db2diag info when the dump occured (01.01.2016 18:58)

Regards,

Prithviraj.