IBM i Configurations
For more detailed install instructions, see the Installation Guide
What the Installation Will Do
Transferring and Installing DataGate for IBM i
Installing DataGate for IBM i onto the IBM i from Windows
Installing DataGate for IBM i onto the IBM i from the IBM i
Changing the Default DataGate TCP Port
Licensing DataGate for IBM i
Entering the License Code on the IBM i
Authority of the User Profile used to Register DataGate
Configuring DataGate for IBM i
Verifying that TCP/IP is Installed Correctly
Configuring Support for Terminal Emulation
Naming a IBM i Database
Configuring Multiple Versions of DataGate for IBM i Using TCP/IP
Troubleshooting DataGate Service
Troubleshooting a DataGate Job that is Not Terminating
Setting up a Subsystem
Troubleshooting Manually Ending Users Jobs
Finding a IBM i IP address
DataGate 15.0 for IBM i is fully supported for the following OS releases:
Please also consult the release notes for information regarding DataGate for
IBM i interoperability with DataGate Client.
Back to Top
Windows is not required for installation of DataGate for
IBM i, but may be used if
desired. The installation notes in this document refer to procedures available in the following Windows releases:
Please consult the installation notes for further details regarding the configuration requirements
for installing DataGate for IBM i.
Back to Top
You will achieve fast, record-level DB2/400 database access from Windows with DataGate for
Whether you are developing your client applications in Visual Basic.NET, C#, Visual RPG.NET,
or Visual RPG Classic, DataGate for IBM i provides the direct file access needed for efficient Client/Server
processing - without SQL and ODBC.
IBM i connectivity is supported for TCP/IP.
DataGate for IBM i retains all IBM i object authority and object locking. Its Remote Program Call support features automatic program initiation and activation, and allows character, numeric and indicator (Boolean) parameter data types.
DataGate for IBM i provides full object control for the IBM i including: creating files; accessing file definitions; adding, deleting and initializing file members; renaming and copying files. It provides full access to CL commands and data areas, and it utilizes all IBM i CPF error messaging.
Note— The user installing DataGate on the IBM
i must have
ASNAINSTonto the IBM i either directly from IBM i CD media or FTP.
DG8SVCPRF. This user profile is created during the installation and the system value for the Printer option will be assigned to this user profile. If the DataGate service job cannot be started, a one page report outlining the possible cause of the problem will be generated for the user
DG8SVCPRFand printed to the assigned printer.
QWTSETP. This is required because the DataGate service "adopts authority" before starting the end user's job (using the user name and password). These programs are the IBM APIs for performing this function.
Back to Top
The procedure to install DataGate for
IBM i on the IBM i consists of 2 parts. The first is to transfer the
DataGate software to the IBM i, either from Windows or the IBM i CD drive, and the second is to
actually install DataGate into the specified IBM i library.
There is one way in which you can transfer DataGate for IBM i to the IBM i from Windows
There is one way in which you can transfer DataGate for IBM i to the IBM i from another IBM i
Refer to the appropriate installation procedure below for the desired transfer method.
Each procedure will have a subheading noting whether the steps are done on the
IBM i or Windows.
The last step in each procedure will be to run the command that actually installs DataGate for IBM i onto the IBM i.
Back to Top
Note: The user installing
DataGate on the IBM i must have
Prior to installation, DO NOT DELETE or RENAME the ASNA_DG8 library.
It is required for all versions of DataGate, even though you may be installing into a library with a different name.
Also, if you are installing to an existing subsystem, please be sure that the subsystem has been
started prior to the installation.
In order to install DataGate for IBM i on the IBM i from a Save file (obtained from the Installation CD), you must have TCP/IP installed on both Windows and on the IBM i. (You must also have FTP installed on your IBM i).
Installing TCP/IP and FTP on the IBM i is beyond the scope of this document. If you do not know whether your IBM i has TCP/IP and/or FTP, please check with your network manager or system provider.
QGPLby entering the following command:
From Windows, click on the Start button, select Run and enter the following command:
‘tcpipaddress’ is either the IBM i’s TCP/IP address such as 199.076.129.35, or a machine name that is registered either in a DNS or a HOSTS file.
where x is the Windows CD-ROM drive.
ASNAINSTfrom the Save file by entering the following command:
RSTLIB ASNAINST DEV(*SAVF) SAVF(QGPL/ASNAINST)
When DataGate for IBM i is installed, it is automatically authorized for one user license. If you wish to authorize more than one licensed use of DataGate for IBM i, obtain a license code from ASNA and then enter InstallLib/REGISTER from IBM i command line.
The installation program will display the ASNA Software License Agreement.
If you agree with the terms of the license, press the F8 key to continue with the installation.
If you do not agree, press the F3 key and the installation will be cancelled.
Next, the installation program displays the installation options. The installation can be cancelled at any time by pressing the F3 key.
Installation Library Option:
Select a library where DataGate for IBM i will be installed. If the library does not exist, it will be automatically created during the installation. The following libraries are not allowed for the installation: QSYS, QGPL, QSPL, QTEMP, VCAT_72 and the distribution library. Libraries called
VCAT_72 are always created.
Select a subsystem where DataGate for IBM i will run. You must also specify the library where the subsystem description is located or where it will be created during the installation. This is required so that the installation program can determine whether the specified subsystem exists or must be created. If the subsystem does not exist, it will be automatically created in the specified library during the installation. If you are installing to an existing subsystem, please be sure that the subsystem has been started prior to the installation.
Service Table Entry Options:
Select the name of the service table entry and the port that DataGate for IBM i will use. The default values are recommended.
Start DataGate Option:
Y’ to have DataGate for IBM i started as soon as the installation has completed.
If you select not to start DataGate, you will have to start it manually with the STRDG8SVR command by entering:
InstallLib is the library into which DataGate for IBM i was installed.
Clear Cache Library Option:
Enter ‘Y’ to clear the DataGate for IBM i cache library. This is recommended. Make sure that there are no active DataGate for IBM i jobs if you select this option.
Back to Top
Note— The user installing DataGate on the
IBM i must have
The following installation processes have two steps.
*USERauthority or higher.
*SECOFRauthority to run it.
Back to Top
See the above section titled
Installing DataGate for IBM i with FTP, starting with step 8,
for detailed instructions and information about the various installation options.
Once the installation is completed, the
ASNAINST Save file is no longer needed, and may be deleted.
ASNAINST library is automatically deleted.
When DataGate for IBM i is installed, it is automatically authorized for one user license. If you wish to authorize more than one licensed use of DataGate for IBM i, obtain a code from ASNA and then
InstallLib/REGISTER from IBM i command line.
WRKSRVTBLE(Work with service table entries) to verify the name of the DataGate service. On the prompt screen, press <enter> and list of table entries is displayed; the entry list is typically in arrival sequence, so this entry should be at or near the bottom of the list. Scroll down the list of entries until you see port 5042. The default DataGate Service name is "
Acceler8DBServer". Write down the Service name and then press the F3 key.
RMVSRVTBLEand press <enter>. In the Service prompt field, enter the name of the DataGate service from the Service Table entry; in the Port prompt field enter "
5042"; and in the Protocol prompt field prompt enter "
tcp". Press <enter> and the entry will be removed from the Service Table.
ADDSRVTBLEand press <enter>. In the Service field prompt enter "
Acceler8DBServer"; in the Port prompt field enter the port number you want to use; in the Protocol prompt field enter "
tcp" (this must be lower-case); and in the Text prompt field enter "
DataGate/400 Service Table Entry" and then press <enter>.
ADDSRVTBLEcommand must match the name in the
TCPSERVICEdata area in the DataGate library (by default it is "
Before DataGate for IBM i may be used on any IBM i, a valid license code, issued by ASNA, must be entered.
For new trials, this code will be sent with the product if the machine serial number and model type are known at the time of shipping.
The code issued with a trial of DataGate for IBM i will license, or register the product to be used on a specified machine up to a specified date. If it is required to move the product onto another machine, upgrade the model type, or extend the trial period, please contact your Distributor or ASNA for a new license code.
Once the product has been purchased, a new license code will be issued to register the product on a permanent basis. This code will be based either on unlimited users, or on a per-user basis.
A new license code is entered, or a current license can be viewed or changed by using the
product’s Registration Assistant program.
When installing the product for the first time, or when an upgrade is installed, the Registration Assistant screen is displayed with the bottom of the screen displaying whether the current License Code is valid or not. If the License Code is valid, press F3 to continue. If not, call ASNA or your Distributor to get a new License Code.
Note— You cannot use the product without a proper License Code.
Enter or verify the information to the display, as detailed below.
The name of the IBM i will automatically display.
The model of the IBM i will automatically display.
The serial number of the IBM i will automatically display.
For a new license, enter the 16-digit license code acquired from ASNA exactly as it is given.
License Type specifies if the licensing is for an individual machine, or for the entire company.
*PERM, which is the default.
*PERM, which is the default.
*UNLIM, which is the default.
The user profile used to register DataGate software must have
*CHANGE authority to
ASNA_DG8 library. Additionally, it must have
*ALL authority to the
DGPCODE4 data area in
if it already exists (say, from a previous registration of the product).
The user profile must have these authorities regardless of the method used to register the program.
As an example, suppose user profile
ADBUSER is to be used to register DataGate.
The successful execution of the following two IBM i commands prior to registration will insure that
the required object authorities will be available to
GRTOBJAUT OBJ(QSYS/ASNA_DG8) OBJTYPE(*LIB) USER(ADBUSER) AUT(*CHANGE)
GRTOBJAUT OBJ(ASNA_DG8/DGPCODE4) OBJTYPE(*DTAARA) USER(ADBUSER) AUT(*ALL)
Remember that the DGPCODE4 data area may not exist yet if DataGate has never been registered on the machine. If so, the second command is not necessary.
REGISTERcommand is used, the user profile in question is the one used to log on to the IBM i interactive session.
Character_Data_Translation_in_DataGate_Rev_2.docis available that discusses IBM i, Windows, and DataGate character translation functionality; past and present. By illuminating DataGate’s translation techniques and corresponding facilities, you are better equipped to configure and maintain robust character data applications. The document assumes some familiarity of applications programming with Windows, the IBM i, and DB2/400 database architecture.
June 13, 2017 © 2007-2017 ASNA. All rights reserved.