|
|
|
IBM i Configurations
Windows 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
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
Upgrading OS/400
Uninstalling DataGate
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.
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.
You will achieve fast, record-level DB2/400 database access from Windows with DataGate for
IBM i.
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 *SECOFR authority.
ASNAINST onto the IBM i either directly from IBM i CD media or FTP.ASNAINST from the ASNAINST save file.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 DG8SVCPRF and printed to the assigned printer.
QSYGETPH and 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.
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.
Note: The user installing
DataGate on the IBM i must have *SECOFR authority.
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.
QSECOFR account.
QGPL by entering the following command:
From Windows, click on the Start button, select Run and enter the following command:
FTP tcpipaddress
‘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.
ASNAINST from the Save file by entering the following command:
RSTLIB ASNAINST DEV(*SAVF) SAVF(QGPL/ASNAINST)
>Installation Library<ENDDG8SVR
ASNAINST/DG8LOAD
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 ASNA_DG8 and VCAT_72 are always created.
Subsystem Options:
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:
Enter ‘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/STRDG8SVR
Where 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.
Note— The user installing DataGate on the
IBM i must have *SECOFR authority.
The following installation processes have two steps.
*USER authority or higher. *SECOFR authority to run it.
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.
The 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.
RMVSRVTBLE and 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.
ADDSRVTBLE and 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>.ADDSRVTBLE command must match the name
in the TCPSERVICE data area in the DataGate library (by default it is "Acceler8DBServer").
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.
InstallLib/REGISTER
Enter or verify the information to the display, as detailed below.
System Name
The name of the IBM i will automatically display.
Model
The model of the IBM i will automatically display.
Serial Number
The serial number of the IBM i will automatically display.
License Key
For a new license, enter the 16-digit license code acquired from ASNA exactly as it is given.
License Type
License Type specifies if the licensing is for an individual machine, or for the entire company.
*PERM,
which is the default.MM/DD/YYYY.*PERM, which is the default.MM/DD/YYYY.
*UNLIM, which is the default.
The user profile used to register DataGate software must have *CHANGE authority to
the ASNA_DG8 library. Additionally, it must have *ALL authority to the
DGPCODE4 data area in ASNA_DG8,
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 ADBUSER:
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.
REGISTER command 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.doc is 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. |