Kbase P16489: Steps to implement Progress/400 on AS/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/10/2008 |
|
Status: Verified
GOAL:
Steps to implement Progress/400 on AS/400
GOAL:
How to create schema holder on a client machine and server schema on the as/400 machine?
GOAL:
How to Start the Progress/400 DataServer broker?
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress 8.x
Progress 9.x
Progress/400 DataServer
FIX:
After the successful installation of the Progress/400 follow the steps below to implement Progress AS/400 product:
Step 1: AS/400 Side
A. Place in library the Progress directory ?do not make any selections but type the following at the first command line:
a. Type: edtlibl
b. Add progv91C and press {enter}
OR
c. addlibe progv91C *last
Use dsplibl to see if the library was added.
B. Create Dictionary Library (Server Schema)
a. Type: dupprodb and press enter
b. Enter the name of the library to be created, for example, mylib
c. To create an empty database select *proempty, which is the default. (Enter "YES" to Create Schema Image if AS/400 Native 4GL compiler is used to run the 4GL program. Create Progress Lock Table ? if yes, defaults to 500.)
d. FOR AS/400 DB2 to PROGRESS ONLY: [Connect to DB2. Type: CHGPRODCT {enter} and it will ask you to enter the DB2 library name.]
C. Create the Service
a. Type: cfgtcp
b. Select 21(configure related tables)-> 1 (work with service table entries) -> select 1 (add)
c. Add service name, port number, and protocol {enter}. Example: A, 4000, tcp
D. Start Broker ? spawns server and server connects to schema
a. Type: strpronet
b. Protocol: protocol entered during cfgtcp section, above (step Ca).
c. Broker/Manager: use QINTER
d. Service Name: service name entered for step Cc. Example: ?a?. If you are using small letters, service name must be in a pair of back tick or quotes
??.
e. Server Job Queue should be the same as step Dc, i.e., in this case QINTER
Use wrkactjob to see if the broker is started. If so, broker name will show. Example: protcpbrk
E. On the Client Side, go into the Services file and add the service name, port number, and tcp that you entered in step Cc, above. (In NT it is found in the c:\winnt\system32\drivers\etc directory.)
Step 2: Client Side
A. Create Schema Holder
a. Go into the Data Dictionary and create an empty database. Connect to the database.
b. Go into Data Administration, Dataserver DB2/400 Utilities, and Create DataServer Schema.
c. Enter library name created in Bb. Example: mylib
d. Network: tcp
e. Host name: Scooby (as an example).
f. Service Name: Example: A (from step Cc). You must have the service name in the Client?s services file.
g. User ID and Password: Specify the user name and password who started the DataServer broker.
h. Can also add any connection parameters.
i. OK (This loads empty definitions from the .dl ? schema server from local machine AS4empty.dl)
B. Load Definitions (Only if AS/400 DB2 Database does not exist ? want to migrate Progress Database to AS/400 DB2 Database)
a. Connect to Sport2000 database (as an example since we have no data in AS/400). Make sure to Data Admin/Database/Select Working Database and select Sports2000.
b. Dump .df and .d:
i. Data Administration > Admin > Dump Data and Definitions:
1. Data Definitions
2. Table Contents
c. Data Admin > Database > Select Working Database and select progv91 (the As/400 database created under the step Bb from the AS/400 section).
d. Data Administration > DataServer > DB2/400 > Progress/400 Data Dictionary
e. Must be in Modify Schema mode for this part only.
f. Admin/Load Data and Definitions/Data Definitions. Use .df created from step Bb.
C. Synchronize Information from under Data Admin/Admin ? brings definitions from AS/400 to client side schema holder. Read only. Select full synchronize and verify.
D. Load Data (Only if AS/400 DB2 Database does not exist ? wants to migrate
Progress Database to AS/400 DB2 Database)
a. Follow step Bd to be in the Progress/400 Data Dictionary window and select
Read only mode.
b. Follow step Bf but choose Table Contents to load the data. Use .d created
from step Bb.
E. This step is to confirm the progress Database is succ.essfully transferred and converted to AS/400 DB2 database.
a. Go back into AS/400 to check that information is now in library (mylib) created in AS/400 ? step Bb.
b. Type strsql at command line.
c. SELECT * from mylib/customer (customer table pulled from Sports2000 - step Bb).
Please read the programming consideration section.
Recompile the applications.
If you are running the AdminServer, start it using the STRADMINSVR. You can look at the default progress value by using CHGPRODFT command. If you either go to the q-shell (qsh) or wrklnk, you can see the progress installation directory..