Symptom
You want to move table data online using the stored procedure ADMIN_MOVE_TABLE.
Other terms
online table move stored procedure, DB2 LUW
Reason and Prerequisites
You are using DB2 9.7 GA and you would like to move table data online.For DB2 9.7 GA, the stored procedure ADMIN_MOVE_TABLEmust notbe used.There is a known problem which will be corrected in DB2 [...]
Symptom
Long runtime to execute HC ITSAM_AP_BTM 00002
Other terms
Deadline table performance improvement, Reorganization functionality of the deadline table in transaction SWF_SLS_DEADL
Reason and Prerequisites
Read of table ‘SWFSLSDEADL’ is taking long time.
Solution
Table(SWFSLSDEADL) index ‘APP’ has been enhanced by including the field ‘STATUS’. It also fixes the reorganization functionality (cleanup of deadlines) of the deadline table in [...]
Symptom
Long runtime to execute HC ITSAM_AP_BTM 00002
Other terms
Deadline table performance improvement
Reason and Prerequisites
Read of table ‘SWFSLSDEADL’ is taking long time.
Solution
Table(SWFSLSDEADL) index ‘APP’ has been enhanced by including the field ‘STATUS’.
————————————————————————
|Manual Pre-Implement. [...]
Symptom
This note contains an overview of all transports and corrections necessary for a certain R/3 release. It is updated on a regular basis.
The following areas are affected:
Errors in the R/3 system (Data Dictionary, tp, R3trans, R3up, saposcol, CCMS, and so on)Missing functions (database monitor, and so on)Checks for Going-Live service
Other terms
DB2/390, DB2 390, DDIC, [...]
Symptom
The note describes a fix that allows to create PLAN_TABLE and DSN_STATEMNT_TABLE according to the IBM DB2 v9.1 documentation.
Other terms
DB2, MVS, OS390, z/OS
Reason and Prerequisites
-
Solution
Please proceed as follows:
1. Download the latest lib_dbsl patch (dbdb2slib.o/so/dll) from Software Marketplace. It should contain the patch text:
DB2-z/OS: PLAN_TABLE & DSN_STATEMNT_TABLE for v9.12. Exchange lib_dbsl and re-start the SAP system.3. [...]
Symptom
R3ta calculation of ranges for packages for large Oracle database tables to be splitted during UNICODE migrations may take very long.
Other terms
R3ta, migration, unicode, table splitter, system copy, package splitting
Reason and Prerequisites
R3ta does not use any Oracle specific optimizations to calculate the ranges for large tables to be split.
Table splitting can be used for [...]
Symptom
You want to reduce large data volume in particular tables
Other terms
Deletion/Archiving of table entries, improving system performance,
Unicode, conversion preparation, SPUMG
Reason and Prerequisites
System performance during Unicode conversion must be improved.
Read the Unicode Conversion Guide.
Solution
This note provides information about tables which show the largest growth in data volume. It is recommended to delete and/or archive [...]
Symptom
This note deals with questions and answers on the subject of the MaxDB/liveCache database structure check (VERIFY). The Database Verify is also designated as CHECK data or CHECK TABLE. The note is both for the customer and support, to answer queries on the topic of a database structure check in a [...]
Symptom
This is the down port of the “table paging” version of the ALV service framework to NW 7.02, SP 2 (ESF-independent part and iTab data source)
Other terms
ALV TP, ALV table paging, ALV service framework
Solution
SAP NetWeaver 7.02
Import Basis Support Package 2.
Symptom
You are executing a Unicode conversion. After the Unicode conversion you notice, that the number of rows in table clusters (e.g. CDCLS) has changed.
Other terms
Unicode conversion, table clusters, CDCLS, EDID4, DOKLU
Reason and Prerequisites
In table clusters the mapping between logical and physical records is not one-to-one. A physical cluster item consists of many logical [...]