Work Management

Technical databases

TCP/IP Ports TCP/IP Ports Required for IBM i Access and Related Functions Ports That Must Be Open to Make an ODBC, Data Transfer, OLE DB, ADO.Net, or JDBC Connection through a Firewall TCP/IP ports needed to access IBM i NetServer Communication Services SRVSPTPRX (default port *IBMSVR 5026) What Is the SRVSPTPRX TCP Server Message TCP6405 Regarding *SRVSPTPRX Found in the QSYSOPR Message Queue as-sts port 3000 (service tools server) QDBGSVR port 3001 rmtjournal port 3777 rmtjournal-ssl port 3889 is-debug-ile port 3825 (STRDBGSVR) as-debug port 4026 (Graphical Debug Server ==>STRTCPSVR *DBG) Getting started with IBM Navigator for i: To open the new Navigator after installing the latest PTFs, use the URL: http://hostname:2001 OR http://hostname:2002/Navigator. If running with TLS, use the default URLs: https://hostname:2010 OR https://hostname:2003/Navigator.

Freeing up disk on your IBM i WRKJOBSCDE Job Schedule Entry Description of Job Scheduler Object QDFTJOBSCD Restore the Jobs on the WRKJOBSCDE Screen Back to the System

Tracking Important System Limits When sending the alert message to QSYSOPR, use the SQL7062 message identifier System Limits on IBM i - January 2018.pdf Alerts for IBM i System Limits System Health Services

Performance Management

Lock Enforcement Rules for allocating objects IBM i on Power - Performance FAQ Performance - File OPEN and CLOSE Operations Causing a High Volume of Disk Activity ( V7R4, V7R5 ) AS/400 Performance Tuning IBM iDoctor for i Overview Intro to Query Optimization DB2 UDB for iSeries Recommending Materialized Views and Indexes with the IBM DB2 Design Advisor Improving Efficiency of I/O Bound Systems Optimizing Batch Job Performance Introduction Journal Analysis and Optimization Designing Applications for Performance Eliminate the Confusion Eliminate the Confusion!. Introduction Journal Analysis and Optimization