SAP on i5/OS - Database Interface Notes
Analysis: SQL0913 ("Row or object in use") | |
Analysis: SQL0913 (after abnormal end of backup) | |
Analysis: MCH2601 ("Lock enforcement rules broken...") | |
HowTo: ALTER TABLE parallel/online | |
LCKW after V5Rx upgrade due to object conversion |
Performance
SAP Note Number | SAP Note |
Analysis of Performance Problems | |
HowTo: Usage of Plan Cache in DB4COCKPIT | |
FOR ALL ENTRIES Performance | |
Client Copy Performance | |
ODP Cleanup Statistics | |
ALL/IO Optimizer Indicator | |
Offline Resource Cleanup (ODP) | |
iSeries:"ALL I/O" and"UPTO ROWS" performance | |
EVI Stage 2 support for SAP NetWeaver BW |
DB Configuration with SAP
SAP Note Number | SAP Note |
iASP: Implementing IASP | |
iASP: Upgrading a system in iASP | |
SQL Cancel | |
SQL Cancel: Default"on" for 3-tier | |
Long Password Support | |
iSeries: More than 1,000 host variables are possible | |
Virtual host and SAP Management Console | |
SAP Systems on DB2/400 & MCOD |
DB Administration
SAP Note Number | SAP Note |
Distribution of data on discs | |
Reorganization of database tables (RGZPFM) |
SQL Packages
SAP Note Number | SAP Note |
SQL Packages | |
SQL Package Handling | |
Deleting SQL Packages | |
Analysis: DBIF_RSQL_INTERNAL_ERROR (DbSl rc=13) at Prepare | |
Analysis: SQL0904 Reason code 7, overflow in SQL package | |
Analysis: SQL0904 (at export with many tables) | |
HowTo: Package Overflow |
Journaling & Backup
SAP Note Number | SAP Note |
IBM i: Current recommendations for journal configuration | |
Online Backup (old) | |
Online Backup (Ragged Save) | |
Decrease Journal Size | |
Automatic journal receiver handling | |
Switching the default journal | |
Analysis: SQL7008 ("... Not valid for operation") | |
Analysis: Error during Online Backup | |
HowTo: Set up journal logging manually |
Hints
SAP Note Number | SAP Note |
Database Hints (Open/Native SQL) | |
Conditional Statement Hints | |
Using QAQQINI with SAP | |
Access plans of single-execution SQL statements |
Codepages
SAP Note Number | SAP Note |
Comparison: ASCII - EBCDIC | |
Accessing ASCII/Unicode DB's with ext. tools |
Multi-Connect
SAP Note Number | SAP Note |
Multi Connect | |
DB2 for LUW Connect over DRDA to DB2 for i5/OS |
Windows/Linux App-Server
SAP Note Number | SAP Note |
XDA Database Client for Windows and LinuxPPC | |
Analysis: XDA Authentication failure to DB2 for i5/OS | |
Win: Applying Application Server Kernel Patches | |
HowTo: Starting Win AppServer from i5/OS Central Host | |
Adjusting Ethernet Performance Manually |
3-tier Installation
SAP Note Number | SAP Note |
3-tier Installation | |
Analysis: No XDA connection via sockets | |
Analysis: CPFB752 ("Internal Error in API") | |
HowTo: Stop QXDAEDRSQL job | |
Manually adjusting ethernet performance | |
Use of Opticonnect | |
Missing activation of OptiConnect | |
Secure Database Connection for IBM i database server |
System Catalogs
SAP Note Number | SAP Note |
System Catalogs point to wrong library | |
HowTo: Regenerating System Catalog Views | |
Analysis: Inconsistent cross reference files? | |
HowTo: Recovery of damaged objects | |
HowTo: Perform RCLSTG in background |
DDIC
SAP Note Number | SAP Note |
Naming Collisions between SQL and System Name | |
Java DDIC: Conflicts between index and table names | |
HowTo: Retrieve Partitioned Table Attributes in ABAP | |
Objects with TABLE_TYPE = P |
JDBC
SAP Note Number | SAP Note |
FAQ: DB2 for i5/OS JDBC | |
HowTo: Switch JDBC Driver | |
File system structure for JDBC drivers | |
HowTo: Access to external DB2 for i5/OS DataSources | |
Exit Programs for JDBC | |
HowTo: Configure JDBC for Config Tool | |
HowTo: Add a remote JEE Instance |