Salesforce

Gateways for IBM i (Magic xpa 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Gateways for IBM i (Magic xpa 3.x)

Magic xpa uses two gateways for IBM i:

  • AS/400 gateway – This gateway is based on native method calls to data access APIs (ISAM method).

  • DB2/400 gateway – This gateway is based on native method calls to the SQL CLI (Call Level Interface).

The main advantages of the Magic xpa for IBM i gateways are:

  • Portable to non-Windows platforms. ODBC cannot work natively on IBM i, UNIX, and Linux systems.

  • Lower CPU usage compared to Java-based connectors.

  • Possibility to call a native IBM i functionality, such as commands, programs, and SQL procedures.

  • Possibility to access the same database via SQL and ISAM methods.

Magic xpa also provides features for activation of DBMS (gateway) logs where you can find very detailed information regarding the gateway’s activities.

Note:

The execution of the Magic xpa for IBM i system is done via an ISAM or SQL gateway and is entirely based on permissions of the relevant user profile.

To troubleshoot database-related issues, you can activate the gateway logging or investigate the job logs of MGCLIENT jobs. By default, MGCLIENT jobs are started with disabled logging. You can change this by using the CHGJOB command.

Reference
Attachment 
Attachment