Windows/ Unix Upgrade

SB+ 5.3.4

STS

Windows/ Unix Upgrade

Document name:...... SB+ 5.3.4 Upgrade Procedure.doc

DateCreated:...... 28 December, 2004

by...... STS

Revision Number:...... 2

Last Edited:...... 23 January, 2019

by...... pti0824

Printed Date:...... 20 April, 2005

1.Table of Contents

1.Table of Contents

2.Windows

2.1File Copy and Setup

2.2Account Upgrade

2.3Re-Catalog and Verify Accounts

2.4Implement EDGE specific menus

3.Unix systems

3.1File Copy and Setup

3.2Account Upgrade

3.3Re-Catalog and Verify Accounts

3.4Implement EDGE specific menus

Important Notes

!!!!Please schedule someone in ERM to regen the code for this client after you finish the upgrade. Failure to do this will cause errors and the client will call the responseline with errors!!!!!

This document is to be used for upgrading SB+ from 5.0.4 to 5.3.4. It also has been modified to show the differences on Unix and Windows.

Start by locating the SB+ 5.3.4 upgrade CD or go to the STS share, and then to IBM Gold CD Downloads.

For Windows, go to the Windows folder, then to the SB+5.3.4 for Windows, then find sb5.3.4.udt.nt.zip.

For UNIX, go to the Unix folder, then to the SB+5.3.4 for Unix folder, then find either sb_udt_534.cpio or sb_udt_534.cpio.Z

2.Windows

!!!!Please schedule someone in ERM to regen the code for this client after you finish the upgrade. Failure to do this will cause errors and the client will call the responseline with errors!!!!!

2.1File Copy and Setup

Be logged into the computer as a member of the Administrators group, most likely the user “excaladm”.

□Unzip the sb5.3.4.udt.nt.zip file into E:\tmp\sb534 assuming EDGE is installed in e:\sb.

□Locate the setup.exe file in \install and execute it.

□It will display a window titled SB+ 5.3.4 for UniData/NT Setup. A “Select Destination Directory” window will be presented with the default destination directory of C:\IBM\SBPlus\UniData.

□Click the Browse button and change the path to the base directory of EDGE, ex.E:\sb.

□Select next, and a setup screen will appear.

□Select “I want to preserve the existing configuration”, then Next.

This step copies \sb\SB to \sb\SB.OLD, \sb\SB.DEFN to \sb\SB.DEFN.OLD, and \sb\SBDEMO to \sb\SBDEMO.OLD; preserving the 5.0.4 SB files.

When it is finished, a Farewell screen is presented. It states “Setup completed successfully. Thank you for installing SB+ 5.3.4 for UniData/NT. Please log to SB+ Admin Account to complete the installation.

2.2Account Upgrade

Next, get setup to do the upgrade by setting environment variables. This example assumes that EDGE is on the E: drive and that Unidata 6.0.x is the current version of the database.

E:\sb\SB>

E:\sb\SB set UDTBIN=e:\ibm\ud60\bin

E:\sb\SB> set UDTHOME=e:\sb\sbsys

E:\sb\SB> udt

UniData Release 6.0 Build: (4214)

Current UniData home is E:\sb\sbsys\.

Current working directory is E:\sb\SB.

Warning: global CTLGTB file path(VOC pointer file) is different than current

Unidata home path, cannot global CATALOG/MAP in this udt session.

The help file 'AE_DOC', is not available. Please ask your

system administrator to put a file pointer in your VOC file.

UDTHOME / CTLGTB mismatch

UDTHOME=E:\sb\sbsys

CTLGTB =C:\IBM\ud60\sys\CTLGTB

Global cataloging cannot be done.

After setting the path to the global catalog,

at ECL use the command AE_RESTART.

Top of "SAPROGS" in "MD", 3 lines, 21 characters.

*--:

002: SAPROGS

*--:

003: D_SAPROGS

Bottom.

*--:

Filed "SAPROGS" in file "MD" unchanged.

WARNING WARNING WARNING

I am about to fix the file pointers for Release 5.3 of SB+

Checking for the SBDEMO account ...

SBDEMO account present for this install.

Updating pointers to dictionary only files for MD ...

115 records selected to list 0.

Updating non-local file pointers for MD ...

91 records selected to list 0.

8 records selected to list 0.

Updating Q file pointers for MD ...

No data retrieved from current (S)SELECT statement.

Updating program pointers for MD ...

704 records selected to list 0.

Updating pointers to dictionary only files for SB.DEFN ...

58 records selected to list 0.

Updating non-local file pointers for SB.DEFN ...

36 records selected to list 0.

Updating local file pointers for SB.DEFN ...

58 records selected to list 0.

11 records selected to list 0.

Updating Q file pointers for SB.DEFN ...

No data retrieved from current (S)SELECT statement.

Updating program pointers for SB.DEFN ...

315 records selected to list 0.

Updating Unidata MD pointers for SB.DEFN ...

11 records selected to list 0.

Updating pointers to dictionary only files for SBDEMO ...

183 records selected to list 0.

Updating non-local file pointers for SBDEMO ...

164 records selected to list 0.

Updating local file pointers for SBDEMO ...

183 records selected to list 0.

5 records selected to list 0.

Updating Q file pointers for SBDEMO ...

No data retrieved from current (S)SELECT statement.

Updating program pointers for SBDEMO ...

691 records selected to list 0.

Updating Unidata MD pointers for SBDEMO ...

14 records selected to list 0.

Updating the DMACCOUNTS entries ...

Fix of file pointers successfully completed !!!

WARNING WARNING WARNING

I am about to install Release 5.3 on your system.

Do you wish to continue (Y/<N>) :Y

Catalog all the SB+ routines ...

The SB+ programs are catalogued globally by default,

Do you wish to catalog the programs locally using DIRECT option (Y/<N>):N

Enter the prefix to use for the globally catalogued programs

or hit <Enter> to use the default prefix "_SB_" : <enter>

CATALOG SB+ OBJECT UTILITY

DM File is in account : SB.DEFN

You are in SB and DM etc is in SB.DEFN

Proceed with cataloging of SB+ Object (Y/N) :Y

Cataloging File TUBPOGS

Item 283 UV.TU.EXECUTE.ITEMCNT.HHE NOTE:This will flip through files

Checking for the SBDEMO account ...

SBDEMO account present for this install.

Finding the full pathname to Unidata ... E:\sb\sbsys ...

Finding the maximum length of a directory name ... 255 characters ...

Installing the CHPROGS entries in the SBDEMO MD.

Updating the SB.CONTROL entry ...

Updating the Global dictionary ...

Updating the DMACCOUNTS entries ...

Updating the SB and LOGIN procs ...

Installation successfully completed !!!

Type SB to start...

2.3Re-Catalog and Verify Accounts

Type, SB

UniData Release 6.0 Build: (4166)

Current UniData home is /sb/sbsys/.

Current working directory is /sb/SB.

G O O D A F T E R N O O N !

W E L C O M E T O S B +

Please Enter User Id : SB

Please Enter Password: <enter>

Validating...

Terminal Id (or * for list) (DEFAULT.TERM) : TU.VT220

Installation program detected previous

SB+ installation. Would you like to

preserve existing configuration? Yes

For Windows, there is a Popup window here that states the same language as above.

Processing the DMCONTACTS file :

Processing the DMDIARY file :

Processing the DMSECURITY file :

Processing the DMUSERLOG file :

Processing the DMDIARY.ARCHIVE file :

Processing the DMACCOUNTS file :

Processing the DICT DMSECURITY file :

Processing the DICT DMUSERLOG file :

Processing the DICT DMDIARY.ARCHIVE file :

Processing the DICT DMACCOUNTS file :

Moving Terminal and Printer related definitions to DMSYSDEFN

Converting Printers to Physical Printers and Printer Classes

Converting Stationery Items

Converting PRINTER.CONTROL and creating PRINTERS.STARTED items

Moving GC.CONTROL item from DMSKELCODE to DMCONT

Upgrade has successfully completed. You may now delete the SB.OLD account.

Press <Enter> to Continue ... enter

This copy of SB+ is licenced to Paradigm Technologies

This software is an unpublished work protected by copyright laws of the US and

other nations. It is proprietary to IBM Corporation and contains trade secrets.

Unauthorized use, disclosure, or duplication is prohibited.

Last logged on TUESDAY, 30 SEP 2003 at 08:44 on Port 1

No New Mail

1 SB SA S Y S T E M A D M I N I S T R A T I O N Date

. Backup SeCurity Admin Office Shell Logto .

Select Shell from this menu

SB> LICENCE.INFO

Display Licence Info

Company / User NameParadigm Technologies

Postal Address Line 11099 18th Street

Postal Address Line 2 Suite 2400 Post/Zip Code

Postal Address Line 3 Denver, CO 80202

Contact: Title First NaSurname

Mr. Todd Roemmich

Email Address:

Telephone Number: Area 303 Number 292-0990

SB+ Serial Number 196P0032 American/International

SB+ Runtime Code

Hardware Manufacturer HP Model Number9000

Computer Serial #

Operating Environment O/E Release

Dealer Name

Licence Number

Reference Code

Number of SB+ Users20

Upgrade

Media Type

Media Density

SB> SB.INFO

SB+ Release Info

SB+ Release5.3

Patch No4

Patch No Date Applied

Host Lib5.3.4.322

SBGC.PARAMS

This lists Code Generation Parameters. Verify that the Catalog Options is set to FORCE NEWPCODE. If it’s set incorrectly, change to Force Newpcode and F2-Save this item.

ÚÄÄÄÄÄÄCode Generation ParametersÄÄÄÄÄÄÄ¿

³ INSERT/INCLUDE Filename ______³

³ Report Diagnostic Flag 1 ³

³ Report INSERT Byte Size 999999 ³

³ Screen INSERT Byte Size 999999 ³

³ Additional Compile Options ³

³ Catalog Options FORCE NEWPCODE ³

³ Trap 'Divide by zero' No ³

SB> SELECT DM

193 record(s) selected.

SB> SAVE.LIST SLDM

193 key(s) saved to 1 record(s).

SB> EDIT.LIST SLDM

SLDM000

The help file 'AE_DOC', is not available. Please ask your

system administrator to put a file pointer in your VOC file.

Top of "SLDM000" in "SAVEDLISTS", 193 lines, 2,634 characters.

*--: C!_!!99999

001: MM

002: SB.ACTIONBAR

003: SB.ARD.RUN

191: SB.XREF.S

192: SB.XTRA.VAL

193: SBSORT

At line 193 (bottom). Changed 193 lines.

*--: FI

Filed "SLDM000" in file "SAVEDLISTS".

SB> GET.LIST SLDM

193 records retrieved to list 0.

SB> DELETE VOC

Do you want to delete records in select list?(Y/N)Y

'MM' deleted.

'SB.ACTIONBAR' deleted.

'SB.ARD.RUN' deleted.

'SB.ARD.S' deleted.

'SB.XREF.S' deleted.

'SB.XTRA.VAL' deleted.

'SBSORT' deleted.

SB> GET.LIST SLDM

193 records retrieved to list 0.

SB> CATALOG DM FORCE

Use select list data(Y/N)? Y

Follow the same 7 step procedure which is:

SELECT DM

SAVE.LIST SLDM

EDIT.LIST SLDM

*--: C!_!!99999
*--: FI

GET.LIST SLDM

DELETE VOC

GET.LIST SLDM

CATALOG DM FORCE

that you just used for DM for:

Name#Records

DMGC15

DMGD19

DMSH71

DMUT98

SAPROGS33

Note: The following Select is different than the previous 6 Selects

SB> SELECT TUBP WITH @ID LIKE _...

213 records selected to list 0.

SB> SAVE.LIST SLTUBP

213 key(s) saved to 1 record(s).

SBEDIT.LIST SLTUBP

*--: C!_!!99999
*--: FI

SB> GET.LIST SLTUBP

213 records retrieved to list 0.

SB> DELETE VOC

Do you want to delete records in select list?(Y/N)Y

SB> GET.LIST SLTUBP

213 records retrieved to list 0.

SB> CATALOG TUBP FORCE

Use select list data(Y/N)? Y

SB> LOGTO SB.EXC

------

Upgrading SB.EXC Accounts' SB+ release from 5.0 to 5.3

Proceed with Upgrade (Y/N) : Y

------

Updating SB+.DEFN file pointers ...

------

Updating SB+ file pointers ...

------

Copying SB+ program pointers

Copying across program pointers for DM...

********************

Copying across program pointers for DMGC...

Copying across program pointers for DMGD...

Copying across program pointers for DMSH...

********

Copying across program pointers for DMUT...

**********

Copying across program pointers for TUBP...

**********************

Copying across program pointers for SAPROGS ...

------

Upgrading System Id ES ...

Updating ESPROCESS ...

------

Upgrading System Id GSD ...

Updating GSDPROCESS ...

At TCL

SB.EXC> WHERE

/sb/SB.EXC

SB.EXC> SB.INFO

SB+ Release Info

SB+ Release5.3

Patch No4

Patch No Date Applied

Host Lib5.3.4.322

SB.EXC> SBCVERSION

=== SBClient Version Information ===

Client Version: 5.3.4.262

Host 3GL API Version: 5.3.4.322, Flavour UDT,BUFFER

Server Type is: 0

SB.EXC> LOGTO SB.TRAIN

------
Upgrading SB.TRAIN Accounts' SB+ release from 5.0 to 5.3

Proceed with Upgrade (Y/N) : Y

------
Updating SB+.DEFN file pointers ...

------

Updating SB+ file pointers ...

------

Copying SB+ program pointers

Copying across program pointers for DM...

********************

Copying across program pointers for DMGC...

Copying across program pointers for DMGD...

Copying across program pointers for DMSH...

********

Copying across program pointers for DMUT...

**********

Copying across program pointers for TUBP...

**********************

Copying across program pointers for SAPROGS ...

------

Upgrading System Id ES ...

Updating ESPROCESS ...

------

Upgrading System Id GSD ...

Updating GSDPROCESS ...

At TCL

SB.TRAIN> WHERE

/sb/SB.TRAIN

SB.TRAIN> SB.INFO

SB+ Release Info

SB+ Release5.3

Patch No4

Patch No Date Applied

Host Lib5.3.4.322

SB.TRAIN> SBCVERSION

=== SBClient Version Information ===

Client Version: 5.3.4.262

Host 3GL API Version: 5.3.4.322, Flavour UDT,BUFFER

Server Type is: 0

2.4Implement EDGE specific menus

In the training account in GUI mode as SB|COMMAND, go to TCL

SB.TRAIN> COPY.SB.ITEMS

SB.TRAIN> LOGTO SB.EXC

SB.EXC> COPY.SB.ITEMS

SB.EXC> MM to get to GUI mode

/ LOGTO SB.TRAIN

Right click on the EDGE desktop, a menu with Functions, Report Manager, Tools, Help, and Logoff should display.

/ LOGTO SB.EXC

Right click on the EDGE desktop, a menu with Functions, Report Manager, Tools, Help, and Logoff should display.

/ OFF

Congratulations!!! You are finished upgrading to SB+ 5.3.4!!!

!!!!! Send an email to ERM telling them that you are finished with the upgrade and that you want them to regen the code!!!!!

3.Unix systems

!!!!Please schedule someone in ERM to regen the code for this client after you finish the upgrade. Failure to do this will cause errors and the client will call the responseline with errors!!!!!

Start by locating the SB+ 5.3.4 upgrade CD or go to the STS share, and then to IBM Gold CD Downloads.

For UNIX, go to the Unix folder, then to the SB+5.3.4 for Unix folder, then find either sb_udt_534.cpio or sb_udt_534.cpio.Z

3.1File Copy and Setup

Put the cpio file in /tmp/SB534 on the client machine.

cd /tmp/SB534

/tmp/SB534 #ll

-rw-r----- 1 unidata unidata 27130880 Apr 27 13:21 sb_udt_534.cpio
/tmp/SB534 #cd /sb

/sb #mv SB SB.OLD

/sb #mv SB.DEFN SB.DEFN.OLD

/sb #mv SBDEMO SBDEMO.OLD

/sb #export UDTBIN=/usr/ud/bin

/sb #export UDTHOME=/sb/sbsys

/sb #umask 007

/sb #sh

/sb #cpio-icvBdum < /tmp/SB534/sb_udt_534.cpio

SB/__V__VIEW

SB/_REPORT_

SB/_SCREEN_

SB/AE_COMS

SB/D___V__VIEW

SBDEMO/GLPROGS

SBDEMO/SAVEDLISTS/List1

SBDEMO/SHAREDLIB

SBDEMO/SHAREDLIB/List1

45640 blocks

/sb #chmod -R 775 SB SB.DEFN SBDEMO

/sb #chown -R unidata:unidata SB SB.DEFN SBDEMO

/sb #cd SB

3.2Account Upgrade

/sb/SB #udt

UniData Release 6.0 Build: (4166)

Current UniData home is /sb/sbsys/.

Current working directory is /sb/SB.

Warning: global CTLGTB file path(VOC pointer file) is different than current

Unidata home path, cannot global CATALOG/MAP in this udt session.

The help file 'AE_DOC', is not available. Please ask your

system administrator to put a file pointer in your VOC file.

UDTHOME / CTLGTB mismatch

UDTHOME=/sb/sbsys

CTLGTB =/db/udt52/sys/CTLGTB

Global cataloging cannot be done.

After setting the path to the global catalog,

at ECL use the command AE_RESTART.

Top of "SAPROGS" in "MD", 3 lines, 21 characters.

*--:

002: SAPROGS

*--:

003: D_SAPROGS

Bottom.

003: D_SAPROGS

Bottom.

*--:

Filed "SAPROGS" in file "MD" unchanged.

WARNING WARNING WARNING

I am about to fix the file pointers for Release 5.3 of SB+

Checking for the SBDEMO account ...

SBDEMO account present for this install.

Updating pointers to dictionary only files for MD ...

111 records selected to list 0.

Updating multilevel data files for MD ...

No data retrieved from current (S)SELECT statement.

Updating non-local file pointers for MD ...

88 records selected to list 0.

No data retrieved from current (S)SELECT statement.

Updating program pointers for MD ...

705 records selected to list 0.

Updating Unidata MD pointers for MD ...

3 records selected to list 0.

No data retrieved from current (S)SELECT statement.

Updating non-local file pointers for SB.DEFN ...

36 records selected to list 0.

Updating local file pointers for SB.DEFN ...

57 records selected to list 0.

10 records selected to list 0.

Updating Q file pointers for SB.DEFN ...

No data retrieved from current (S)SELECT statement.

Updating program pointers for SB.DEFN ...

322 records selected to list 0.

Updating Unidata MD pointers for SB.DEFN ...

4 records selected to list 0.

Updating pointers to dictionary only files for SBDEMO ...

179 records selected to list 0.

Updating multilevel data files for SBDEMO ...

No data retrieved from current (S)SELECT statement.

Updating non-local file pointers for SBDEMO ...

161 records selected to list 0.

Updating local file pointers for SBDEMO ...

179 records selected to list 0.

5 records selected to list 0.

Updating Q file pointers for SBDEMO ...

No data retrieved from current (S)SELECT statement.

Updating program pointers for SBDEMO ...

692 records selected to list 0.

Updating Unidata MD pointers for SBDEMO ...

4 records selected to list 0.

Updating the DMACCOUNTS entries ...

Fix of file pointers successfully completed !!!

WARNING WARNING WARNING

I am about to install Release 5.3 on your system.

Do you wish to continue (Y/<N>) : Y

Catalog all the SB+ routines ...

The SB+ programs are catalogued globally by default,

Do you wish to catalog the programs locally using DIRECT option (Y/<N>) : N

Enter the prefix to use for the globally catalogued programs

or hit <Enter> to use the default prefix "_SB_" : <enter>

CATALOG SB+ OBJECT UTILITY

DM File is in account : SB.DEFN

You are in SB and DM etc is in SB.DEFN

Proceed with cataloging of SB+ Object (Y/N) : Y

Cataloging File SAPROGS

Item 33 SB.EXECUTE

Cataloging File DM

Item 193 SE

Cataloging File DMGC

Item 15 GC.VALIDATE

Cataloging File DMGD

Item 19 GD.VALID.TEXT

Cataloging File DMSH

Item 71 SH.WHO

Cataloging File DMUT

Item 97 UT.WHERE.AM.I

Cataloging File TUBP

Item 1 ACCESS.HEADER.H

Item 281 UV.TU.EXECUTE.ITEMCNT.H

Configuring SB+ Print management

Do you wish to use USAM:Print printer management functions (Y/<N>) : N

Checking for the SBDEMO account ...

SBDEMO account present for this install.

Enter the SB+ group name (up to eight characters) : unidata

Finding the full pathname to Unidata ... /sb/sbsys ...

Finding the maximum length of a directory name ... 255 characters ...

Installing the CHPROGS entries in the SBDEMO MD.

Updating the SB.CONTROL entry ...

Updating the .profile entry for SB and SBDEMO ...

Updating access permissions of the SB SB.DEFN SBDEMO accounts ...

... SB ... done.

... SB.DEFN ... done.

... SBDEMO ... done.

Updating the group of the SB SB.DEFN SBDEMO accounts ...

... SB ... done.

... SB.DEFN ... done.

... SBDEMO ... done.

Updating the owner of the SB SB.DEFN SBDEMO accounts ...

... SB ... done.

... SB.DEFN ... done.

... SBDEMO ... done.

Updating the Global dictionary ...

Updating the DMACCOUNTS entries ...

Updating the SB and LOGIN procs ...

Installation successfully completed !!!

Please type in the following commands at the # prompt :

umask 007 <enter>

newgrp unidata <enter>

cd /sb/SB <enter>

./.profile <enter>

and you will automatically be logged into Unidata and presented

with the SB+ login screen. Please consult the SB+ manual as to

how to proceed.

NOTE: As the root user you must issue the above commands

whenever you wish to log into SB+ from this directory.

Not doing so will jeopardize the integrity of SB+

Also, new Unix users must be setup - via the

"sysadm usermgmt" function of Unix. They must

be in the unidata group, have /sb/SB

as their initial directory, and have the Bourne

shell ie /bin/sh as their initial shell.

Press <enter> to continue ... <enter>

3.3Re-Catalog and Verify Accounts

/sb/SB #cat .profile

stty erase '^H' kill '^U' intr '^C' quit '^_' -tabs ff0 cr0 nl0 icrnl -olcuc -iu

clc echoe ofill clocal -hupcl susp ''

umask 007

UDTHOME=/sb/sbsys

UDTBIN=/usr/ud/bin

export UDTHOME UDTBIN

SCHDIR=$UDTBIN/sch

PATH=$PATH:$UDTBIN:$UDTBIN/sch/sprint/bin

export PATH SCHDIR

exec udt

/sb/SB #./.profile

UniData Release 6.0 Build: (4166)

Current UniData home is /sb/sbsys/.

Current working directory is /sb/SB.

G O O D A F T E R N O O N !

W E L C O M E T O S B +

Please Enter User Id : SB

Please Enter Password: <enter>