Skip to Content
IBM Db2 for i

SAP on i5/OS - Database Interface Notes


Analysis: SQL0913 ("Row or object in use")

139339

Analysis: SQL0913 (after abnormal end of backup)

80938

Analysis: MCH2601 ("Lock enforcement rules broken...")

960392

HowTo: ALTER TABLE parallel/online

444524

LCKW after V5Rx upgrade due to object conversion


Performance

SAP Note Number

SAP Note

101113

Analysis of Performance Problems

1083218

HowTo: Usage of Plan Cache in DB4COCKPIT

531337

FOR ALL ENTRIES Performance

517589

Client Copy Performance

125661

ODP Cleanup Statistics

705888

ALL/IO Optimizer Indicator

732071

Offline Resource Cleanup (ODP)

898203

iSeries:"ALL I/O" and"UPTO ROWS" performance

501572

EVI Stage 2 support for SAP NetWeaver BW


DB Configuration with SAP

SAP Note Number

SAP Note

568820

iASP: Implementing IASP

1039748

iASP: Upgrading a system in iASP

494086

SQL Cancel

705887

SQL Cancel: Default"on" for 3-tier

705886

Long Password Support

805622

iSeries: More than 1,000 host variables are possible

1120970

Virtual host and SAP Management Console

443925

SAP Systems on DB2/400 & MCOD


DB Administration

SAP Note Number

SAP Note

654801

Distribution of data on discs

84081

Reorganization of database tables (RGZPFM)


SQL Packages

SAP Note Number

SAP Note

93503

SQL Packages

29929

SQL Package Handling

63037

Deleting SQL Packages

214594

Analysis: DBIF_RSQL_INTERNAL_ERROR (DbSl rc=13) at Prepare

54028

Analysis: SQL0904 Reason code 7, overflow in SQL package

548037

Analysis: SQL0904 (at export with many tables)

1109573

HowTo: Package Overflow


Journaling & Backup

SAP Note Number

SAP Note

1449715

IBM i: Current recommendations for journal configuration

202593

Online Backup (old)

825473

Online Backup (Ragged Save)

448552
424866

Decrease Journal Size

82079

Automatic journal receiver handling

744055

Switching the default journal

116192

Analysis: SQL7008 ("... Not valid for operation")

1061267

Analysis: Error during Online Backup

828354

HowTo: Set up journal logging manually


Hints

SAP Note Number

SAP Note

485420

Database Hints (Open/Native SQL)

1109771

Conditional Statement Hints

820325

Using QAQQINI with SAP

481868

Access plans of single-execution SQL statements


Codepages

SAP Note Number

SAP Note

39510

Comparison: ASCII - EBCDIC

554792

Accessing ASCII/Unicode DB's with ext. tools


Multi-Connect

SAP Note Number

SAP Note

146624

Multi Connect

663756

DB2 for LUW Connect over DRDA to DB2 for i5/OS


Windows/Linux App-Server

SAP Note Number

SAP Note

751451

XDA Database Client for Windows and LinuxPPC

585468

Analysis: XDA Authentication failure to DB2 for i5/OS

564395

Win: Applying Application Server Kernel Patches

682281

HowTo: Starting Win AppServer from i5/OS Central Host

449187

Adjusting Ethernet Performance Manually


3-tier Installation

SAP Note Number

SAP Note

484548

3-tier Installation

47712

Analysis: No XDA connection via sockets

576371

Analysis: CPFB752 ("Internal Error in API")

98222

HowTo: Stop QXDAEDRSQL job

449187

Manually adjusting ethernet performance

187241

Use of Opticonnect

189749

Missing activation of OptiConnect

1288331

Secure Database Connection for IBM i database server


System Catalogs

SAP Note Number

SAP Note

66985

System Catalogs point to wrong library

852158

HowTo: Regenerating System Catalog Views

71258

Analysis: Inconsistent cross reference files?

831678

HowTo: Recovery of damaged objects

826305

HowTo: Perform RCLSTG in background


DDIC

SAP Note Number

SAP Note

696249

Naming Collisions between SQL and System Name

853456

Java DDIC: Conflicts between index and table names

712572

HowTo: Retrieve Partitioned Table Attributes in ABAP

380968

Objects with TABLE_TYPE = P


JDBC

SAP Note Number

SAP Note

654800

FAQ: DB2 for i5/OS JDBC

826449

HowTo: Switch JDBC Driver

809693

File system structure for JDBC drivers

924753

HowTo: Access to external DB2 for i5/OS DataSources

654794

Exit Programs for JDBC

657117

HowTo: Configure JDBC for Config Tool

657115

HowTo: Add a remote JEE Instance

Former Member

No comments