You will achieve fast, record-level DB2/400 database access from Windows with DataGate/400. Whether you are developing your client applications in Visual Basic, C, C++ , ASNA Visual RPG, ASNA Database Toolbox for Java, DataGate/400 provides the direct file access needed for efficient Client/Server processing - without SQL and ODBC.

AS/400 connectivity is supported for TCP/IP.

DataGate/400 retains all AS/400 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/400 provides full object control for the AS/400 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 AS/400 CPF error messaging.

This chapter contains the installation procedures for installing, configuring and troubleshooting DataGate/400.

Contents

· What the Installation Will Do

· Transferring and Installing DataGate/400

· Installing DataGate/400 from the PC

· Installing DataGate/400 from the AS/400

- Using AS/400 tape media

- Using AS/400 CD-Rom drive

· Configuring DataGate/400

- For TCP/IP access

· Naming an AS/400 Database

· Configuring Multiple Versions of DataGate/400

· Setting up a Subsystem

· Troubleshooting

What the Installation Will Do

On the AS/400

· Restore the temporary library, ASNADLVR onto the AS/400 either directly from AS/400 media.

· Restore the library ASNATEMP from the Save file in ASNADLVR.

· Install DataGate/400 to library DG8_40.

On the PC

· Restore PC programs, by default, to the \Datagate\FTP folder.

Prior to installation, if DataGate is running on the AS/400, you must first stop the service (e.g., DG8_40/ENDDG8SVR) and all DataGate sessions.
DO NOT delete or rename the DG8_40 library. It is required for all versions of DataGate even though you may be installing into different library names.

Back To Top

Transferring and Installing DataGate/400

The procedure to install DataGate/400 on the AS/400 consists of 2 parts. The first is to transfer DataGate/400 to the AS/400, either from a PC or AS/400 media, and the second is to actually install DataGate/400 onto the AS/400.

There is 1 way in which you can transfer DataGate/400 to the AS/400 from the PC

· FTP

There are 2 ways in which you can transfer DataGate/400 to the AS/400 from the AS/400

· AS/400 Tape Media

· A CD-Rom on the AS/400

Refer to the appropriate installation procedure below consisting of the desired transfer method. Each procedure will have a subheading noting whether the steps are done on the AS/400 or the PC.

The last step in each procedure will be to run the command that actually installs DataGate/400 onto the AS/400.

Back To Top

Installing DataGate/400 onto the AS/400 from the PC

Installing DataGate/400 using FTP

In order to install DataGate/400 on the AS/400 from a Save file (obtained from the Installation CD), you must have TCP/IP installed on both your PC and on the AS/400. (You must also have FTP installed on your AS/400).

Installing TCP/IP and FTP on the AS/400 is beyond the scope of this document. If you do not know whether your AS/400 has TCP/IP and/or FTP, please check with your network manager or system provider.

On the AS/400

1. Sign onto the AS/400 using an account with *SECOFR authority.

2. On the AS/400, create a library (temporary) called ASNADLVR. (Note: QTEMP must not be used).

CRTLIB ASNADLVR

3. Add this library to the library list:

ADDLIBLE ASNADLVR

4. Create a Save file in the same library as the physical file:

CRTSAVF FILE(ASNADLVR/DG8SF)

On the PC

5. To upload the Save file from the CD or PC, an FTP session must be started to the AS/400.

From Windows, click on the START button, select RUN and enter the following command:

FTP as400tcpipaddress

where as400tcpipaddress is either a TCP/IP address such as 198.176.129.35, or a machine name that is registered either in a DNS or a HOSTS file.

6. When prompted for a user name and password, enter the appropriate information that will give you privileges to upload data to the AS/400.

7. Once FTP has been started, upload the Save file to the AS/400 by entering the following commands:

a) binary

b) put <path> ASNADLVR/DG8SF

where <path> is the location of the save file on disk. This could be on a CD-ROM or wherever you extracted the save file to.

Examples of path: D:\Datagate\

C:\ASNA\Dg8400\

c) quit

On the AS/400

8. Restore the library called ASNATEMP from the Save file in ASNADLVR.

RSTLIB SAVLIB(ASNATEMP) DEV(*SAVF) SAVF(ASNADLVR/DG8SF)

9. To install DataGate/400, execute one of the following commands (depending on version):

If you are installing version 5.1200.1.51 or previous, issue this command:

ASNATEMP/LODDG8 library name

· where library name is optional. If a library name is not specified, DataGate/400 will be installed to the library DG8_40.

If you are installing version 5.1200.1.64 or later, issue this command:

ASNATEMP/DG8LOAD

When DataGate/400 is installed, it is automatically authorized for one user license. If you wish to authorize more than one license to DataGate for the AS/400, obtain a code from ASNA and enter it using ASNA's Registration Assistant from Start - Programs - ASNA Product Suite on the PC.

10. Once the installation has completed, the library ASNADLVR is no longer needed, and may be deleted. (The ASNATEMP library is automatically deleted).

11. If accessing the AS/400 via TCP/IP, the DataGate server will have to be configured for TCPIP access. See Configuring TCP/IP on Windows for more information.

12. You must name the AS/400 Database in Acceler8DB Database Manager using Work with Database Names. See Naming an AS/400 Database for more information.

Back To Top

Installing DataGate/400 onto the AS/400 from the AS/400

The following installation processes have two steps.

· The first step is to restore a temporary installation library and can be done by anyone with *USER authority or higher.

· The second step does the actual installation and initialization of the product and requires *SECOFR authority to run it.

Installing DataGate/400 from AS/400 Tape Media

To Install from AS/400 Tape Media

1. Load the Installation tape. Enter the following command to restore the Install program to the ASNATEMP library:

RSTLIB ASNATEMP TAP01

TAP01 refers to the device name from which the object will be restored. If an alternative tape drive is being used, enter the appropriate device name.

2. Once the library is restored, sign onto the AS/400 with *SECOFR authority and execute the following command:

ASNATEMP/LODDG8 library name

· where library name is optional. If a library name is not specified, DataGate/400 will be installed to the library DG8_40.

Once the installation is completed, the ASNATEMP library is automatically deleted.

3. If accessing the AS/400 via TCP/IP, the DataGate server will have to be configured for TCPIP access. See Configuring TCP/IP on Windows 98 for more information.

4. You must name the AS/400 Database in Acceler8DB Database Manager using Work with Database Names. See Naming an AS/400 Database for more information.

Back To Top

Installing DataGate/400 using an AS/400 CD-ROM drive

To Install from AS/400 CD-Rom Drive

1. To restore the installation library, load the CD, then enter the following command:

RSTLIB ASNATEMP OPT01 OPTFILE('DATAGATE/RSTLIB/ASNATEMP')

(where OPT01 refers to the device name from which the object will be restored)

2. Then enter the following command:

ASNATEMP/LODDG8

If accessing the AS/400 via TCP/IP, the DataGate server will have to be configured for TCPIP access. See Configuring TCP/IP on Windows 98 for more information.

3. You must name the AS/400 Database in Acceler8DB Database Manager using Work with Database Names. See Naming an AS/400 Database for more information.

Back To Top

Licensing DataGate/400

Before DataGate/400 may be used on any AS/400, 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/400 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 on either unlimited users, or on a per-user basis.

Back To Top

Entering the License Code on the AS/400

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 can not use the product without a proper License Code.

To Enter, Display, or Change a License Code on the AS/400

1. If you are not already at the Registration Assistant Screen, enter the following:

a. ADDLIBLE LIB(DG8_40) POSITION(*FIRST)

b. DG8_40/REGISTER

Enter or verify the information as detailed below.

System Name

The name of the AS/400 will automatically display.

Model

The model of the AS/400 will automatically display.

Serial Number

The serial number of the AS/400 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.

· To license, or register the current machine, use *MACH, which is the default.

· To license, or register the entire company, enter *SITE.

Customer Name

The name of the user that was entered when the product was installed will automatically display. However, you can change this name as needed.

The customer name is case-sensitive and must match the customers name exactly as ASNA's account shows.

Company Name

The name of the company that was entered when the product was installed will automatically display. However, you can change this name as needed.

If you are entering a Site License, the name of the company must be spelled exactly as determined by you and ASNA. This name is also case-sensitive, so capitalization must match exactly.

Start Date

The Start Date specifies if the product has been purchased, in which you have a Permanent code, or if the product is a ‘Trial’, which is only valid for a specified period.

· If the product has been purchased, use *PERM, which is the default.

· For a ‘Trial’ of the product, enter the starting date in the format MM/DD/YYYY.

Expiration Date

The Expiration Date indicates the date in which the license code will expire.

· If the product has been purchased, use *PERM, which is the default.

· For a ‘Trial’ of the product, enter the ending date of the trial as specified by ASNA in the format MM/DD/YYYY.

User Count

User Count specifies the number of concurrent users that can access the product, as a per-user-basis, or as unlimited.

· For unlimited users, use *UNLIM, which is the default.

· For a specified number of users, enter the user count as a positive integer.

3. Acceptance of a valid licensing code is confirmed at the bottom of the screen. Press F3 to continue.

If the message “The License is Invalid” displays, recheck all entries. If no errors were made in any of the entries, call ASNA or your National Distributor for further assistance.

If the message “Couldn't create license data area, check authority and try again" displays, you do not have the proper authority to register DataGate/400. See Authority of the User Profile used to Register DataGate for more information.

Back To Top

Entering the License Code on the PC

To register a DataGate/400 license code, the user profile used must have *CHANGE authority to the DG8_40 library. Additionally, it must have *ALL authority to the DGPCODE data area in DG8_40. See Authority of the User Profile used to Register DataGate for additional information.

To Enter a License Code on the PC

1. After installing DataGate/400, contact ASNA to obtain a License Key.

2. Open Registration Assistant by selecting Start - Programs - ASNA Product Suite - ASNA Registration Assistant and select DataGate/400 as the product by clicking on the arrow to the right.

3. Select the database nameDatabase_Name that points to the database on the AS/400 in which you are registering a license for.

The database name for the AS/400 to be licensed must already exist on the system running Registration Assistant. Use Acceler8DB Database Manager to register a database name by selecting Work with Database Names… from the File menu.

Once a database name is selected, the Model and Serial number of the AS/400 will automatically display.

4. Enter the License Key that you received from ASNA, along with the rest of the information as listed below. Select the Register Product button when finished.

Machine Code

Machine Code is a unique number that represents a “signature” of your system and will automatically display. The code is separated into groups of 4-digit numbers. It will contain 16 numbers (except for AVR 2.2 and earlier). The Machine Code can not be changed.

If for any reason you lose your machine code, please contact ASNA.

AS/400 Model

The model of the AS/400 will automatically display after selecting a database name to license.

Serial Number

The serial number of the AS/400 will automatically display after selecting a database name to license.

License Key

A 16-digit license key acquired from ASNA. You may enter the License Key as a single, large number. However, for easier readability, it is recommended to enter one or more spaces between each set of 4 digits. Note that this is not necessary, and spaces will not affect the License Key.

Database Name

Select the database name on the AS/400 in which you are registering a license for.

Name

The name of the user that was entered when the product was installed will automatically display. However, you can change this name as needed.

Company

The name of the company that was entered when the product was installed will automatically display. However, you can change this name as needed.

If you are entering a Site LicenseSite_License, the name of the company must be spelled exactly as determined by you and ASNA. This name is also case-sensitive, so capitalization must match.

Version

The version (and build number) of the selected product will automatically display.

Full Version

A full version indicates that you have full use of the product, i.e., you can compile and make .EXE’s, DLL’s, and OCX’s. The full version can be set as either permanent or temporary.

Trial Version

A trial version indicates that you do not have full use of the product, i.e., you can not compile and make .EXE’s, DLL’s, and OCX’s.

When you install Visual RPG 3.x on a system in which Visual RPG has never been installed before, you are automatically given a “trial” version of AVR. A trial version is good for approximately 30 days, so you do not need to enter a license key until the product is purchased and you have received a permanent license key from ASNA.

Site License

Check this box if your company is set up with a Site License, in which multiple licenses have been acquired that will all use the same License Key.

Unlimited

Select Unlimited if the number of users that can access Acceler8DB Engine or DataGate/400 is not limited to a particular number.

Limited

Select Limited if there is a limit to the number of users that can access Acceler8DB Engine or DataGate/400. If limited is selected, enter the number of concurrent users that can access Acceler8DB Engine or DataGate/400 in User CountUser_Count.

User Count

Enter the number of concurrent users that can access Acceler8DB Engine of DataGate/400. This option will only display if a user type of LimitedLimited was selected.

Date format

Select the date format in which you will enter the StartingStart and EndingEnd date for the license. The two formats are:

mm/dd/yyyy (USA)

dd/mm/yyyy (UK)

Permanent

The license period is permanent for this system. There is no startStart or endEnd date.

You will not need to contact ASNA for another license unless there is a changeASNA_Registration_Assistant to your system.

Temporary

The license period is temporary. You must specify a startStart and endEnd date.

Start

Enter the starting date of the licensing of the specified product according to the date formatDate_format you have selected. This is the date in which the product was installed.

End

Enter the ending date of the licensing of the specified product according to the date formatDate_format you have selected. This should be approximately 30 days in which the product was installed. However, if you need an extension to the trial period, please contact ASNA. ASNA_Registration_Assistant

5. Acceptance of a valid licensing code is displayed. Select OK to clear the message, then select Exit to close Registration Assistant.

If you receive Acceler8DB error number 654 - “Not authorized to Object" after selecting the Register button, you do not have the proper authority to register DataGate/400. See Authority of the User Profile used to Register DataGate below for more information.

Back To Top

Authority of the User Profile used to Register DataGate

The user profile used to register DataGate software must have *CHANGE authority to the DG8_40 library. Additionally, it must have *ALL authority to the DGPCODE data area in DG8_40, 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, such as the AS/400 REGISTER command or the Windows PC Registration Assistant program.

As an example, suppose user profile ADBUSER is to be used to register DataGate. The successful execution of the following two AS/400 commands prior to registration will insure that the required object authorities will be available to ADBUSER:

GRTOBJAUT OBJ(QSYS/DG8_40) OBJTYPE(*LIB) USER(ADBUSER) AUT(*CHANGE)

GRTOBJAUT OBJ(DG8_40/DGPCODE) OBJTYPE(*DTAARA) USER(ADBUSER) AUT(*ALL)

Remember that the DGPCODE data area may not exist yet if DataGate has never been registered on the machine. If so, the second command is not necessary.

· If the Registration Assistant is used, the user profile is the "Username" specified on the Work With Database Names dialog box of Acceler8DB File Manager, and other tools.

· If the REGISTER command is used, the user profile in question is the one used to log on to the AS/400 interactive session.

Back To Top

Configuring DataGate/400

ASNA DataGate® 5.0 for iSeries/400®

Contents

DataGate/400 Installation Instructions

What the Installation Will Do

Transferring and Installing DataGate/400

Installing DataGate/400 using FTP

Installing DataGate/400 from AS/400 Tape Media

Installing DataGate/400 using an AS/400 CD-ROM drive

Entering the License Code on the AS/400

System Name

Model

Serial Number

License Key

License Type

Customer Name

Company Name

Start Date

Expiration Date

User Count

Entering the License Code on the PC

Authority of the User Profile used to Register DataGate

Configuring TCP/IP on Windows 9801/24/2008 © 2007. Amalgamated Software of North America. All rights reserved.

ASNA DataGate^® 5.0 for iSeries/400^®