AS/400 Integrated Netfinity Server for internet use 1

[abacuscorp]

Good day all:

Has anyone had any experience installing and using the PC under the covers of the AS/400 for web serving? We have a model 620, V4R5 and have had a suggestion that hosting our website internally using this approach would be to our benefit. Any thoughts, experiences, etc. would be appreciated. Thank you.

Warren

 

[os400]

imho, it's a good way to go. I have a 270 @v4r5m0 with the pc card installed. I loaded Win2k server @sp3, apache, php & mysql. Also loaded client access odbc drivers. I've tried my best to stay away from IIS for security reasons. Response times are good.
You'll need to do some setup on the 400 side for db2 connection:

Preparing DB2 for AS/400 to accept connections
The IBM AS/400 has a special service that must be run and other steps that need to be taken:

Name the database and make a *LOCAL entry Command WRKRDBDIRE. There should be an entry with a remote location name of *LOCAL. The relational database name specified with that entry is the external name of the AS/400 database. Typically this is the same name as the system name.

Set the code page to 37 for the user that connects (TBD in a php script), change the CCSID parameter from *SYSVAL to 37, or change it system-wide: WARNING: Code Page 37 is US-English, if you're not using english on your system then you need to do further research on how these code pages work.
DON'T MAKE ANY CHANGES SYSTEM WIDE WITHOUT CONSIDERING THE CONSEQUENCES. CERTAINLY DON'T CHANGE IT SYSTEM WIDE IF YOUR SYSTEM IS NOT RUNNING US-ENGLISH.

CHGUSRPRF USRPRF(user) CCSID(37)
or CHGSYSVAL SYSVAL(QCCSID) VALUE(37)

Start a service to listen on port 446. To start the service once: STRTCPSVR SERVER(*DDM)
To automatically start the service: CHGDDMTCPA AUTOSTART(*YES)

Create a NULLID collection by issuing the following SQL statement: CREATE COLLECTION NULLID

Possibly create a collection for the user ID to connect with: CREATE COLLECTION userid

You can find this info at

http://www.php-faq.com/as400.php

hope this helps