July 27, 2009 at 8:21 am
Symptom
Opening a database connection in an SAP work process takes a very long time. The SAP work process is blocked during this time.
Other terms
SQL_ATTR_LOGIN_TIMEOUT, DB6, UDB, LUW, logical unit of work, DB2UDB, DB2LUW
Reason and Prerequisites
Some SAP applications periodically open secondary database connections for different databases. An example are the data extractors of the [...]
July 15, 2009 at 8:04 am
Symptom
This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.01 and SAP Basis Release 7.11.
This SAP Note includes other required SAP Notes that are regularly extended and updated. Therefore, you can use this SAP Note in transaction SNOTE as a generic update mechanism for [...]
July 15, 2009 at 8:03 am
Symptom
This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.00 and SAP Basis Release 7.10.
This SAP Note includes other required SAP Notes that are regularly extended and updated. Therefore, you can use this SAP Note in transaction SNOTE as a generic update mechanism for [...]
July 14, 2009 at 7:30 am
Symptom
To better support DB2 row compression (also known as deep compression) and DB2 load, we have added new options for installing SAP products to the R3load. These options are delivered with DB2 Version 9 for Linux, UNIX and Windows.
Other terms
DB6, UDB, DB2UDB, LUW, DB2LUW
Reason and Prerequisites
R3load supports the generic option
-loadprocedure dbsl|fast [fastload argument]
Until [...]
July 8, 2009 at 9:11 pm
Symptom
The db2diag.log fills up with the following messages:
2009-05-20-12.54.45.235332-240 E1660A535 LEVEL: Warning
PID : 2257034 TID : 14138 PROC : db2sysc
0
INSTANCE: xxxxxx NODE : 000 DB : xxx
APPHDL : 0-39 APPID:
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
AUTHID : xxxxxx
EDUID : 14138 EDUNAME: db2agent (xxx) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool,
probe:2000
DATA #1 : String, 55 bytes
Sending a signal to clean up NOT THREADED FMP process:
DATA [...]
July 7, 2009 at 9:06 am
Symptom
DB2 9.1 FP4SAP “V9.1.0.4″, “special_19276″.
DB2 might crash with Signal #11 (SIGSEGV) due to a bad pointer.
Other terms
DB2, DB6, UDB, Fixpak, crash, Signal #11 (SIGSEGV)
Reason and Prerequisites
db2level:
DB21085I Instance “db2rdp” uses “64″ bits and DB2 code release “SQL09014″ with level identifier “01050107″.
Informational tokens are “DB2 v9.1.0.4″, “special_19276″, “U811793_19276″, and Fix Pack “4″.
Due to a bad pointer [...]