Creating a new pathcode/environment on B7331/2

SSAJAROFF

Reputable Poster
Hi there!

Many people have already asked me how to create a brand new
pathcode/environment (for example a new PAR733 environment with
its own pathcode PARB733 and accessing JDE_PARALLEL / JDE_PARB733
databases).
I've done this document, already used it on B7331 and B7332 and
it works fine. Nevertheless, I didn't test it on Xe.
It was designed for NT/SQL, but should be quite easy to adapt
for other platforms/databases.

Sebastian Sajaroff

I assume that the new environment is going to be named PAR733 (Parallel Testing),
with its pathcode PARB733 and databases JDE_PAR and JDE_PARB733.
This environment will be created from data and objects of CRP733/CRPB733.

1) Server preparation

1.1) Create database JDE_PAR on the Enterprise. Give it a minimal size of 500 Mb, with
autoexpansion of 15 Mb, log size 50 Mb with autoexpansion of 15 Mb. Check that both
database options "Truncate Log on Checkpoint" and "Insert into bulk copy" are turned off.
Time : 5 m.

1.2) Create database JDE_PARB733 on the Enterprise. Give it a minimal size of 2000 Mb, with
autoexpansion of 15 Mb, log size 50 Mb with autoexpansion of 15 Mb. Check that both
database options "Truncate Log on Checkpoint" and "Insert into bulk copy" are turned off.
Time : 20 m.

1.3) Create SQL logins PARDTA, PARCTL, PARB733 with access to every database including
JDE_PAR and JDE_PARB733. Password should match the login name.
Time : 5 m.

1.4) Allow every SQL login to access both JDE_PAR and JDE_PARB733 databases.
Time : 20 m.

1.5) Grant Create Table permissions for PUBLIC group on both JDE_PAR and JDE_PARB733 databases.
Time : 5 m.

1.6) Add JDE_PAR and JDE_PARB733 to your usual backup script.
Time : 5 m.

2) OneWorld Activities

2.1) Log in any workstation with JDE on CRP733.
Time : 5 m.

2.2) Goto GH9011, Database Data Sources, choose System - B733, and create 4 datasources with
the following information (it's case and spaces sensitive!)

2.2.1) Backup database JDEB733
Time : 5 m.

2.2.2)
Datasource Use = DB
Datasource Name = Business Data - PAR
Datasource Type = S
Object Owner Id = PARDTA
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Business Data - PAR
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Business Data - PAR" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PAR, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.2.3)
Datasource Use = DB
Datasource Name = Control Tables - Par
Datasource Type = S
Object Owner Id = PARCTL
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Control Tables - Par
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Control Tables - Par" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PAR, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.2.4)
Datasource Use = DB
Datasource Name = Central Objects - PARB733
Datasource Type = S
Object Owner Id = PARB733
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Central Objects - PARB733
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Central Objects - PARB733" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PARB733, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.2.5)
Datasource Use = DB
Datasource Name = Versions - PARB733
Datasource Type = S
Object Owner Id = PARB733
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Versions - PARB733
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Versions - PARB733" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PARB733, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.2.6) In case of accident, restore JDEB733 database.

2.3) Goto GH9011, Database Data Sources, choose ENTERPRISE - B733 Server Map, and create
4 datasources with the following information (case and space sensitive!)

2.3.1) Backup database JDEB733.
Time : 5 m.

2.3.2)
Datasource Use = DB
Datasource Name = Business Data - PAR
Datasource Type = S
Object Owner Id = PARDTA
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Business Data - PAR
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Business Data - PAR" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PAR, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.3.3)
Datasource Use = DB
Datasource Name = Control Tables - Par
Datasource Type = S
Object Owner Id = PARCTL
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Control Tables - Par
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Control Tables - Par" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PAR, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.3.4)
Datasource Use = DB
Datasource Name = Central Objects - PARB733
Datasource Type = S
Object Owner Id = PARB733
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Central Objects - PARB733
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Central Objects - PARB733" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PARB733, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.3.5)
Datasource Use = DB
Datasource Name = Versions - PARB733
Datasource Type = S
Object Owner Id = PARB733
Library Name = <blank>
Library List Name = <blank>
DLL Name = JDBODBC.DLL
Database Name = Versions - PARB733
Server Name = <your ENTERPRISE name>
Platform = NTSVR
Use Table Owner = Checked
Use Julian Dates = Checked
Use Decimal Shift = Checked
Support for Updates = Checked
OCM Data Source = Non Checked
AS/400 Blob Data Source = Non Checked
Click OK
OneWorld will ask you to create a Windows DSN ODBC, choose System Data Source, use
"Versions - PARB733" for Name and Description, Server = <your ENTERPRISE name>,
choose SQL Authentication, User JDE and its password, Database = JDE_PARB733, check both
ANSI parameters, uncheck "Translated text".
Time : 5 m.

2.4) OneWorld definition of PARB733 pathcode. Goto GH9053, Pathcode Master, Add and fill
the following fields (case and space sensitive!)

Name = PARB733
Description = B733 - Parallel Path
Location = <your DEPLOYMENT name>
Server Share Path = B733
Status Code = 1
Merge Option = 1
Release = B733
Deployment Data Source = Central Objects - PARB733
UNC Flag = Y
Click OK
In case a "Select librarian datasource" windows appears, choose "Object Librarian - B733"
Time : 5 m.

2.5) OneWorld definition of PAR733 environment. Goto GH9053, Environment Master, Add and fill
the following fields (case and space sensitive!). Be aware that pathcode and environment
should have different names PARB733 and PAR733 (that helps to avoid confusion).

Name = PAR733
Description = B733 Parallel Environment
Pathcode = PARB733
Release = B733
Just in Time Installation = Y
Developer = Y
WAN Configured Environment = N
Time : 5 m.

2.6) Creation of OCM Entries for both System and Enterprise. The easy way to do this is to
copy definitions from CRP733, alter them for PAR733 and insert them.

2.6.1) Backup JDEB733 SQL Database.
Time : 5 m.

2.6.2) Import the table sysb733.f986101 into an Access temporary table TTEMP.
Be aware that you have to import the table, don't dynamically link it!
Time : 5 m.
2.6.3) Run the following scripts into the TTEMP Access table (one a time)

DELETE * FROM TTEMP WHERE OMENHV<>'CRP733'
UPDATE TTEMP SET OMENHV='PAR733' WHERE OMENHV='CRP733'
UPDATE TTEMP SET OMDATP='Business Data - PAR' WHERE OMDATP='Business Data - CRP'
UPDATE TTEMP SET OMDATP='Control Tables - Par' WHERE OMDATP='Control Tables - PAR'
UPDATE TTEMP SET OMDATP='Central Objects - PARB733' WHERE OMDATP='Central Objects - PARB733'
UPDATE TTEMP SET OMDATP='Versions - PARB733' WHERE OMDATP='Versions - PARB733'
Time : 10 m.

2.6.4) Copy every record from TTEMP Access table into both sysb733.f986101 and svmb733.f986101
SQL Tables. You may copy and paste from TTEMP Access table into SQL linked sysb733.f986101
and svmb733.f986101. After that copy, unlink these tables from Access.
Time : 5 m.

2.6.5) In case of accident, restore database from 2.6.1)

2.7) Physical pathcode creation.

2.7.1) From the Deployment Windows Explorer, copy the \\Deployment\B733\CRPB733 folder to
\\Deployment\B733\PARB733.
Time : 30 m.

2.7.2) Remove everything from \\Deployment\B733\PARB733\PACKAGE except DATA and DATACOMP
folders.
Time : 10 m.

2.7.3) Edit \\Deployment\B733\PARB733\DATA\Setup.Inf and rename any CRPB733 string to PARB733.
Time : 5 m.

2.7.4) Rename \\Deployment\B733\PARB733\DATACOMP\CRPPACKAGEDATACOMP.INF as PARPACKAGEDATACOMP.INF
Time : 5 m.

2.7.5) Open PARPACKAGEDATACOMP.INF and rename every CRPB733 string to PARB733.
Time : 5 m.

2.7.6) From the Enterprise Windows Explorer, copy the \B7332\CRPB733 to \B7332\PARB733.
Time : 15 m.

2.8) Deployment setup.

2.8.1) Backup \\Deployment\B733\Planner subdirectory and JDEB733 SQL database.
Time : 45 m.

2.8.2) Log in the Deployment as user JDE with DEPB733 environment and repeat every step from
2.2 to 2.5; if information already exists don't modify it. On Data Sources creation, be sure
to double click every new datasource, click OK and create the Windows ODBC datasource; this
will allow client installation of these new ODBC entries.
Time : 60 m.

2.8.3) Log in the Deployment as user JDE with JDEPLAN environment and repeat every step from
2.2 to 2.5; if information already exists don't modify it.
Time : 60 m.

2.8.4) Open the \\Deployment\B733\Planner\JDEB7.MDB Access database and ensure that the
content of Access tables F0094, F00941, F00942, F986101 absolutely match their SQL equivalents :
sysb733.f0094, sysb733.f00941, sysb733.f00942 and sysb733.f986101.
In case of mismatching or missing information, always assume that SQL information is good
and complete or update every necessary record on the corresponding Access tables.
Time : 60 m.

2.8.5) Repeat the 2.8.4) steps for \\Deployment\B733\Planner\JDEPLAN.MDB Access database.
Time : 60 m.

2.8.6) In case of accident, restore Planner directory and JDEB733 SQL database.

2.8.7) Enter OCM and verify that JDE user runs every UBE locally.

2.9) Object copying.

2.9.1) Log in a workstation as user JDE, go to Fastpath, BV, select UBE R98403, click Find,
highlight version XJDE0022. Click Copy button and fill the following fields : Name = XPAR0022,
Security = 0, Version Title = Control Tables Copy.
Time : 5 m.

2.9.2) Do a Find, highlight XPAR0022 version, click Processing Options, and fill in the
following parameters :
1 = <Blank>
2 = Control Tables - Par
3 = '2'
4 = Control Tables - CRP
5 = <Blank>
6 = '2'
7 = <Blank>
8 = '1'
9 = <Blank>
10 = <Blank>
11 = <Blank>
12 = <Blank>
Click Ok
Time : 5 m.

2.9.3) Highlight the XPAR0022 versions, click Select, check your Processing Options, click
OK and Submit it. Choose "On Screen". This report copies every Control Table from CRP733 to
PAR733.
Time : 20 - 60 m.

2.9.4) Log in a workstation as user JDE, go to Fastpath, BV, select UBE R98403, click Find,
highlight version XJDE0021. Click Copy button and fill the following fields : Name = XPAR0021,
Security = 0, Version Title = Business Data Copy.
Time : 5 m.

2.9.5) Do a Find, highlight XPAR0021 version, click Processing Options, and fill in the
following parameters :
1 = <Blank>
2 = Business Data - PAR
3 = '2'
4 = Business Data - CRP
5 = <Blank>
6 = '2'
7 = <Blank>
8 = '1'
9 = <Blank>
10 = <Blank>
11 = <Blank>
12 = <Blank>
Click Ok
Time : 5 m.

2.9.6) Highlight the XPAR0021 versions, click Select, check your Processing Options, click
OK and Submit it. Choose "On Screen". This report copies every Business Data table from CRP733
to PAR733.
Time : 10 m to 90 m for every 1 Gb of data, depends on network, database and disk speed.

2.9.7) Log in a workstation as user JDE, go to Fastpath, BV, select UBE R98403, click Find,
highlight version XJDE0019. Click Copy button and fill the following fields : Name = XPAR0019,
Security = 0, Version Title = Specifications Copy.
Time : 5 m.

2.9.8) Do a Find, highlight XPAR0019 version, click Processing Options, and fill in the
following parameters :
1 = <Blank>
2 = Central Objects - PARB733
3 = '2'
4 = Central Objects - CRPB733
5 = <Blank>
6 = '2'
7 = <Blank>
8 = '1'
9 = <Blank>
10 = <Blank>
11 = <Blank>
12 = <Blank>
Click Ok
Time : 5 m.

2.9.9) Highlight the XPAR0019 versions, click Select, check your Processing Options, click
OK and Submit it. Choose "On Screen". This report copies every spec table from CRP733
to PAR733.
Time : 120 m to 480 m depends on network, database, disk speed, and package size.

2.9.10) Create OL records. You have to replicate F9861 CRP records for PAR pathcode.
To do that, run INSERT INTO OBJB733.F9861 SELECT SIOBNM,SIMKEY,SIENHV,SIUSER,SIDM,SIJDEVERS,
SIMSAR,SISTCE,SIDVP,SIMRGMOD,SIMRGOPT,SIRLS,'PARB733' AS SIPATHCD,SIMODCMT,SIPID,SIJOBM,
SIUPMJ,SIUPMT FROM OBJB733.F9861 WHERE SIPATHCD='CRPB733'

3) Package deploy.

3.1) Create a full client PARB733 package. Follow the usual instructions and install it.
Time : 120 m to 480 m depends on network, database, disk and processor speed.

3.2) Insert the new Enterprise pathcode PARB733 sysb733.f9651, and F9651 on both
JDEB7 and JDEPLAN Access databases
Time : 5 m.

3.3) Insert the new Pathcode records for PARB733 into PACKAGE.INF (Enterprise server),
copy the records of CRP (and replace them with PAR)
Time : 5 m.

3.4) Create a full server PARB733 package. Follow the usual instructions and install it.
Time : 120 m to 480 m depends on network, database, disk and processor speed.

3.5) Manually create ODBC entries for PAR733 Environment on the Enteprise Server.

B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
ssajaroff@grupoassa.com
Grupo ASSA - Application Software SA
 
Top