Loading...
Loading...
Found 20 Skills
Analyzes legacy RPG (Report Program Generator) programs from AS/400 and IBM i systems for migration to modern Java applications. Extracts business logic from RPG III/IV/ILE source code, identifies data structures (D-specs), file operations (F-specs), program dependencies (CALLB/CALLP), and converts RPG constructs to Java equivalents. Generates migration reports, complexity estimates, and Java implementation strategies with POJO classes, JPA entities, and service methods. Use when modernizing AS/400 or IBM i legacy systems, analyzing RPG source files (.rpg, .rpgle, .RPGLE), converting RPG to Java, mapping data specifications to Java classes, planning legacy system migration, or when user mentions RPG analysis, Report Program Generator, RPG III/IV/ILE, AS/400 modernization, IBM i migration, packed decimal conversion, or mainframe application rewrite.
Query, monitor, and analyze jobs on IBM i using SQL table functions via ibmi-mcp-server. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (7) any IBM i work management task.
Browse, search, read, and inspect files in the IBM i Integrated File System (IFS) including authorities, locks, and server shares. Use when user asks about: (1) listing IFS directory contents, (2) searching for files by name or pattern, (3) reading text file contents, (4) checking file authorities or permissions, (5) diagnosing file lock contention, (6) finding large files consuming disk space, (7) viewing NetServer file shares, or (8) replacing WRKLNK, DSPAUT, DSPLNK command output.
Monitor and analyze IBM i network and communication resources including TCP/IP connections, network interfaces, routing, HTTP servers, and DNS configuration via SQL services. Use when user asks about: (1) active network connections and traffic, (2) network interface status and IP addresses, (3) routing tables, (4) HTTP server configuration and status, (5) TCP/IP settings and hostname, (6) NTP/SNTP time synchronization, (7) network attributes, or (8) replacing NETSTAT, WRKTCPSTS, CFGTCP, WRKhttpsrvr commands.
Monitor IBM i database performance including index statistics, maintained temporary indexes (MTIs), database monitors, query supervisor thresholds, and materialized query tables. Use when user asks about: (1) index usage or unused indexes, (2) maintained temporary indexes and whether to create permanent indexes, (3) database monitor configuration, (4) query supervisor thresholds, (5) MQT statistics and refresh status, or (6) tables with high MTI overhead.
Query IBM i system configuration including system values, hardware resources, device status, environment variables, and JVM settings via SQL services. Use when user asks about: (1) system value settings like QSECURITY or QCCSID, (2) security-related system values, (3) hardware resource inventory, (4) controller, device, or line status, (5) environment variable settings, (6) active JVM information, (7) replacing DSPSYSVAL, DSPHDWRSC, WRKCFGSTS, WRKENVVAR commands, or (8) any system configuration review.
Manage and analyze spooled files, output queues, and printer configurations on IBM i via SQL services. Use when user asks about: (1) listing or searching output queues, (2) viewing spooled file entries by queue, user, or status, (3) reading spool file content, (4) identifying top spool consumers or old spool files, (5) printer file definitions, (6) spool storage analysis, (7) replacing WRKSPLF, WRKOUTQ, WRKOBJLCK commands, or (8) any spool file management task.
Monitor Java Virtual Machines running on IBM i including heap memory usage, garbage collection activity, thread counts, and JVM configuration. Use when user asks about: (1) active JVMs on the system, (2) JVM heap or memory consumption, (3) garbage collection performance, (4) Java thread counts, (5) JVM home directories or properties, (6) identifying JVMs at risk of OutOfMemoryError, or (7) replacing WRKJVMJOB command output.
Query and explore IBM i application objects including CL commands, data areas, data queues, programs, environment variables, exit programs, and watches via SQL services. Use when user asks about: (1) CL command attributes or discovery, (2) data area values or inventory, (3) data queue status and messages, (4) program information (ILE/OPM), (5) environment variables, (6) registered exit programs, (7) watch sessions, (8) user spaces or user indexes, or (9) replacing DSPCMD, DSPDTAARA, DSPLIB, DSPPGM commands.
Explore and manage the IBM i SQL plan cache including snapshots, event monitors, and procedure references. Use when user asks about: (1) plan cache services or procedures available, (2) plan cache snapshot files on the system, (3) plan cache event monitor status, (4) how to dump or manage the plan cache, (5) plan cache sizing or QSQSRVR job memory usage, or (6) SQL syntax for plan cache management operations.
Manage and inspect IBM i journals, journal receivers, journaled objects, journal entries, remote journals, and audit journal data marts. Use when user asks about: (1) listing journals or journal receivers, (2) which objects are journaled, (3) reading journal entries, (4) remote journal configuration and lag, (5) journal receiver sizes or chains, (6) SMAPP access path protection, (7) audit journal data marts, (8) journal storage consumption, or (9) replacing WRKJRN, DSPJRN, WRKJRNA command output.
Monitor Db2 Mirror for IBM i including replication status, cluster topology, NRG communication, RDMA links, replication criteria, resynchronization, reclone readiness, and flight recorder diagnostics. Use when user asks about: (1) mirror replication status or health, (2) cluster node topology, (3) NRG or RDMA link status, (4) takeover IP addresses, (5) replication inclusion/exclusion rules, (6) resynchronization progress, (7) reclone security objects, (8) mirror version compatibility, (9) flight recorder logging, or (10) ObjectConnect state.