LeasePak
Server Upgrade and Conversion
Start here if you have a previous installation of LeasePak on your server. If you are installing LeasePak for the first time, refer to the document LeasePak Server Preparation and Installation.
MSI recommends that you monitor both
the terminal output and the use of DBMS server resources during the upgrade and conversion process.
The terminal output contains important analysis and results, while reaching limits on DBMS resources could
suspend the conversion process.
System Requirements
Review the document System Requirements for possible changes in requirements between your current LeasePak version and version .
Procedure Overview
Which steps you complete to upgrade LeasePak and convert LeasePak databases (Oracle schemas and/or Sybase databases) depends on what your current version of LeasePak is. Please follow the procedures specific to your current version.
Versions Earlier than 4.2a
If you are currently running a version of LeasePak earlier than 4.2a, do not use any of these procedures. Contact your MSI representative for assistance.
Version
If you have already installed a release of LeasePak , skip the steps specified for earlier versions and proceed directly to Updating LeasePak .
Versions 4.2a - 5.0a
If you are currently running LeasePak version 4.2a, 4.3a, 4.4a, 4.5a, 4.6a, or 5.0a, use the following steps to upgrade to LeasePak .
- Versions 4.2a - 5.0a: Prepare the server for an upgrade.
- Version 4.2a only: Complete the steps for transferring to a 64-bit platform.
- Versions 4.2a - 5.0a: Complete the steps for upgrading to LeasePak .
Server Preparation
Complete this section if you are currently running LeasePak version 4.2a, 4.3a, 4.4a, 4.5a, 4.6a, or 5.0a. Do not delete your current installation until you have successfully completed the upgrade.
User Processes
Notify users in advance that the server will be unavailable during the upgrade. At the scheduled start time, use the following steps to stop any remaining user processes
- Log on the server as root
- Use the ps command to list LeasePak drivers running on the server
ps -ef | grep lpa
This not only lists instances of the main LeasePak program lpadriver.exe, but also lists other LeasePak processes, such as the End of Period program lpaeopdrvr.exe and the LeasePak utilities program $uexe/lpautil.exe.
- If any of these processes need to be stopped, use the kill command
kill id
where id is the process id number.
Sybase only: list (and stop, if needed) any
remaining processes within Sybase
- Start isql in 132-column mode
isql -Usa -w132
- Use sp_who to list user processes. The terminal will display something similar to the following
fid spid status loginame ... dbname --- ---- ----------- -------- ---------- 0 1 running sa master 0 7 recv sleep ernesto production
- If any of these processes need to be stopped, use the kill command
kill spid
where spid is the process id number.
- Start isql in 132-column mode
End of Period
Run End of Period for all portfolios in all environments you are upgrading. After End of Period is finished, do not make changes to any of the databases. You may also want to limit user access to the server and DBMS server once End of Period is complete.
Versions Before 5.1a Only: Environment and Database Backups
Make a copy of all environment directories and archive them to tape.
Sybase only: Use the Sybase dump
utility to make copies of system databases (such as master, sybsystemprocs, and
tempdb) and all LeasePak databases and archive them to tape.
Server Backup
Perform either a full or incremental server backup as needed.
Version 4.2a: continue to the next
section, Transferring to a 64-Bit Platform. Version 4.3a, 4.4a, 4.5a, 4.6a, or 5.0a: Skip the next section and
proceed to Upgrading to LeasePak .
HP, Sybase: Transferring to a 64-Bit Platform
Complete this section only if you are currently running LeasePak version 4.2a.
Directory Backups
Back up the following directories, including all subdirectories and files, and archive them to tape (if you can retrieve the directories from your server backup, you do not need to back them up separately).
- LeasePak release directory (/opt/msi/version, where version is the LeasePak release you are upgrading)
- Sector7 release directory (/opt/sector7/version, where version is the LeasePak release you are upgrading)
- Sector7 license file (/etc/S7.license)
- users' home directories (/home/*)
- user password file (/etc/passwd)
Sybase Account Names
After upgrading Sybase, you will need to recreate the Sybase account. Use these steps to save a list of the account names
- Using cat, create a script to use within isql
cat > get_names.sql <<stop
where the script contains the following lines
? use master ? go ? select name from syslogins ? go ? stop
- Use isql to run the script and save the output to a file
isql -Usa -Psa_password -iget_names.sql > $HOME/login_names.rpt
where sa_password is the sa password.
HP-UX Installation and Configuration
Install HP-UX 11.00, 64-bit environment, and required patches as specified in System Requirements, then use the procedures listed in LeasePak Server Preparation and Installation to complete the configurations needed for Sybase 12.0 and LeasePak .
MSI strongly recommends installing the OS from scratch rather than upgrading to the new version.
Sybase Installation and Configuration
Perform the pre-installation configurations described in Sybase 12.x Server, install Sybase 12.0.0.2 runtime license, 64 bit, and required patches as specified in System Requirements, then perform the remaining configurations as detailed in Sybase 12.x Server to complete the preparation needed for LeasePak .
If you plan on maintaining older versions of Sybase in addition to 12.0, contact your MSI representative for assistance before installing the new version.
Restoring Directories
After completing the installation and configuration of HP-UX and Sybase, restore the contents of the LeasePak and Sector7 release directories, as well as the LeasePak environment directories.
$SYBDIR and $SYBSRV
If the Sybase directory path or server name values changed with the new installation of Sybase, edit the $top/install/installenv.msirc file to make the necessary changes to $SYBDIR and $SYBSRV
Recreating Databases
Log on the server as msidba and use create_db_syb without using setup_new_env to recreate databases for the 4.2a snapshots made earlier.
Restoring Data
Use the Sybase load utility to restore data to the LeasePak databases.
LeasePak version 4.2a does not run on a 64-bit
platform; these procedures are part of the upgrade process only.
Version 4.2a: continue to the next
section, Upgrading to LeasePak .
Upgrading to LeasePak
Complete this section if you are currently running LeasePak version 4.2a, 4.3a, 4.4a, 4.5a, 4.6a, or 5.0a.
Version 4.2a: if you have not already done so, complete the section Transferring to a 64-Bit Platform before continuing to this section.
LeasePak Server Preparation
Review the required OS server and DBMS server preparations in LeasePak Server Preparation and Installation before installing LeasePak .
LeasePak Installation
Complete the following sections from LeasePak Server Preparation and Installation
Upgrading LeasePak Environments
Use the LeasePak script upgrade_env to upgrade all LeasePak environments you are including in the conversion.
To upgrade an environment
- Log on the server as msiadmin
- Run upgrade_env
upgrade_env [new-setup-env-flags] path-to-old-environment-to-upgrade [build-id]
where new-setup-env-flags are the optional flags and build-id is the build descriptor as described in the Environment and Database Configuration section of LeasePak Server Configuration and Maintenance.
- The terminal will display something similar to the following
-03-06 03:12:23 upgrade_env: Start /opt/msi//prod -03-06 03:12:24 setup_new_env: PRODUCTION prod syb SERVER_SYBASE lpr_prod live; Start -03-06 03:12:25 setup_new_env: Creating environment directory structure... -03-06 03:12:25 setup_new_env: Creating syb_use... -03-06 03:12:25 setup_new_env: Creating logdb.*... -03-06 03:12:27 setup_new_env: Creating envdb.msirc... -03-06 03:12:28 setup_new_env: Creating msidba placeholders... -03-06 03:12:28 setup_new_env: Creating .lp*... -03-06 03:12:28 setup_new_env: Setting environment security... You will need the following for Leasepak PC Client setup: IP Address or name: server Environment name: prod Server Port: -03-06 03:12:29 setup_new_env: End -03-06 03:12:29 upgrade_env: Cannot delete old environment. Please remove it manually -03-06 03:12:29 upgrade_env: End
Terminal emulation: you must use one of the supported terminal types. Refer to the Terminal Emulation section of the document System Requirements for more information.
.lplogin and .lpprofile
If needed, copy the .lplogin and .lpprofile files from the $top/env/environment/etc directory (where environment is the upgraded LeasePak environment to the $HOME directory of the environment's LeasePak administrative user (lpadmin, not msiadmin; leave msiadmin tied to the administrative environment) and modify them to create the appropriate startup files, or log on the server as msiadmin and run change_env to switch the environments. For more information on .lplogin and .lpprofile, refer to the lpadmin section of the document LeasePak Server Configuration and Maintenance.
Converting LeasePak Databases
Use the LeasePak script sgenlpux_conversion to convert all LeasePak databases you are including in the upgrade.
The optional flags and flag arguments available with sgenlpux_conversion are for MSI testing and debugging purposes only. MSI recommends using the basic sgenlpux_conversion syntax described below; consult your MSI representative before using this script with any of the optional flags.
To convert a database
- Log on the server as msidba
- change to the $top/env/environment/conv directory, where environment is the environment whose database you are converting
- Run sgenlpux_conversion
sgenlpux_conversion environment starting-release [dbo-password [srvadm-password]]
where environment is the name of the environment whose database you are converting, starting-release is your version of LeasePak before the upgrade (for example, v50a), dbo-password is the database owner password, and srvadm-password is the DBMS server administrator password. For the dbo-password and srvadm-password, do not enter these on the command line; LeasePak will prompt you for them if and when necessary.
- The terminal will display something similar to the following, then prompt for the srvadm password
-03-03 00:54:10 sgenlpux_conversion: Convert prod environment from v50a to -03-03 00:54:10 sgenlpux_conversion: Start Server Administrator password:
- Type the srvadm password and press Enter. The terminal will prompt for the
dbo password
-08-23 14:21:03 sgenlpux_conversion: Running commands as DBO: lpr_test Database Owner 'OWNER' password:
- Type the dbo password for the database and press Enter. The conversion may take several minutes. The following
is a complete example of the terminal display for the remainder of sgenlpux_conversion
(your display will be slightly different)
-08-23 14:21:14 db_get_dbo: Start -08-23 14:21:14 db_get_dbo: Fetching current DBO ... -08-23 14:21:15 db_get_dbo: Current DBO is 'lpr_test' (USER) -08-23 14:21:16 db_set_dbo: Start -08-23 14:21:16 db_set_dbo: Rewriting the logdb.msirc ... -08-23 14:21:16 db_set_dbo: Rewriting logdb.*... -08-23 14:21:19 db_set_dbo: No errors detected -08-23 14:21:19 db_set_dbo: End -08-23 14:21:20 sgenlpux_conversion: Turning on fast bcp option... -08-23 14:21:24 sgenlpux_conversion: Add table rbi... -08-23 14:21:25 sgenlpux_conversion: Add table rcgb... -08-23 14:21:25 sgenlpux_conversion: Add table rdu... -08-23 14:21:26 sgenlpux_conversion: Add table rpu... -08-23 14:21:26 sgenlpux_conversion: Add table rsb... -08-23 14:21:26 sgenlpux_conversion: Add table ruf... -08-23 14:21:27 sgenlpux_conversion: Add table rut... -08-23 14:21:28 sgenlpux_conversion: Add table rxu... -08-23 14:21:28 sgenlpux_conversion: Altering table mwa... gencon: Start: /08/23 14:21:28 mwa alter mwa: added t_enter_trk_s gencon: End: /08/23 14:21:28 -08-23 14:21:28 sgenlpux_conversion: Altering table rapa... gencon: Start: /08/23 14:21:28 rapa alter rapa: added orig_intfc_s gencon: End: /08/23 14:21:28 -08-23 14:21:28 sgenlpux_conversion: Altering table rcg... gencon: Start: /08/23 14:21:29 rcg alter rcg: added max_units_on_lse_l gencon: End: /08/23 14:21:29 -08-23 14:21:29 sgenlpux_conversion: Altering table rfs... gencon: Start: /08/23 14:21:29 rfs alter rfs: added hilight1_s rfs: added hilight2_s rfs: added hilight3_s gencon: End: /08/23 14:21:29 -08-23 14:21:29 sgenlpux_conversion: Altering table rhsb... gencon: Start: /08/23 14:21:29 rhsb alter rhsb: added recovery_d rhsb: added valuat_res_d gencon: End: /08/23 14:21:29 -08-23 14:21:29 sgenlpux_conversion: Altering table rlsb... gencon: Start: /08/23 14:21:29 rlsb alter rlsb: added valuat_res_d rlsb: added recovery_d gencon: End: /08/23 14:21:29 -08-23 14:21:29 sgenlpux_conversion: Altering table rua... gencon: Start: /08/23 14:21:29 rua alter rua: added field37_s rua: added field38_s rua: added field39_s rua: added field40_s rua: added field41_s rua: added field42_s rua: added field43_s rua: added field44_s rua: added field45_s rua: added field46_s rua: added field47_s rua: added field48_s rua: added field49_s rua: added field50_s rua: added field51_s gencon: End: /08/23 14:21:29 -08-23 14:21:29 sgenlpux_conversion: Altering table rud... gencon: Start: /08/23 14:21:29 rud alter rud: added field37_s rud: added field38_s rud: added field39_s rud: added field40_s rud: added field41_s rud: added field42_s rud: added field43_s rud: added field44_s rud: added field45_s rud: added field46_s rud: added field47_s rud: added field48_s rud: added field49_s rud: added field50_s rud: added field51_s gencon: End: /08/23 14:21:30 -08-23 14:21:30 sgenlpux_conversion: Altering table rug... gencon: Start: /08/23 14:21:30 rug alter rug: added field37_s rug: added field38_s rug: added field39_s rug: added field40_s rug: added field41_s rug: added field42_s rug: added field43_s rug: added field44_s rug: added field45_s rug: added field46_s rug: added field47_s rug: added field48_s rug: added field49_s rug: added field50_s rug: added field51_s gencon: End: /08/23 14:21:30 -08-23 14:21:30 sgenlpux_conversion: Altering table ruj... gencon: Start: /08/23 14:21:30 ruj alter ruj: added field37_s ruj: added field38_s ruj: added field39_s ruj: added field40_s ruj: added field41_s ruj: added field42_s ruj: added field43_s ruj: added field44_s ruj: added field45_s ruj: added field46_s ruj: added field47_s ruj: added field48_s ruj: added field49_s ruj: added field50_s ruj: added field51_s gencon: End: /08/23 14:21:30 -08-23 14:21:30 sgenlpux_conversion: Altering table rum... gencon: Start: /08/23 14:21:30 rum alter rum: added field37_s rum: added field38_s rum: added field39_s rum: added field40_s rum: added field41_s rum: added field42_s rum: added field43_s rum: added field44_s rum: added field45_s rum: added field46_s rum: added field47_s rum: added field48_s rum: added field49_s rum: added field50_s rum: added field51_s gencon: End: /08/23 14:21:30 -08-23 14:21:30 sgenlpux_conversion: Altering table ruo... gencon: Start: /08/23 14:21:30 ruo alter ruo: added field37_s ruo: added field38_s ruo: added field39_s ruo: added field40_s ruo: added field41_s ruo: added field42_s ruo: added field43_s ruo: added field44_s ruo: added field45_s ruo: added field46_s ruo: added field47_s ruo: added field48_s ruo: added field49_s ruo: added field50_s ruo: added field51_s gencon: End: /08/23 14:21:31 -08-23 14:21:31 sgenlpux_conversion: Altering table rur... gencon: Start: /08/23 14:21:31 rur alter rur: added field37_s rur: added field38_s rur: added field39_s rur: added field40_s rur: added field41_s rur: added field42_s rur: added field43_s rur: added field44_s rur: added field45_s rur: added field46_s rur: added field47_s rur: added field48_s rur: added field49_s rur: added field50_s rur: added field51_s gencon: End: /08/23 14:21:31 -08-23 14:21:31 sgenlpux_conversion: Add index(es) on table msvb... -08-23 14:21:32 sgenlpux_conversion: Add index(es) on table msvc... -08-23 14:21:32 sgenlpux_conversion: Add index(es) on table msvh... -08-23 14:21:32 sgenlpux_conversion: Add index(es) on table msvi... -08-23 14:21:33 sgenlpux_conversion: Add index(es) on table msvl... -08-23 14:21:33 sgenlpux_conversion: Add index(es) on table msvr... -08-23 14:21:34 sgenlpux_conversion: Add index(es) on table msvs... -08-23 14:21:34 sgenlpux_conversion: Add index(es) on table msvu... -08-23 14:21:34 sgenlpux_conversion: Add index(es) on table msvv... -08-23 14:21:35 sgenlpux_conversion: Add index(es) on table mxd... -08-23 14:21:35 sgenlpux_conversion: Add index(es) on table rbi... -08-23 14:21:36 sgenlpux_conversion: Add index(es) on table rcgb... -08-23 14:21:36 sgenlpux_conversion: Add index(es) on table rdu... -08-23 14:21:36 sgenlpux_conversion: Add index(es) on table rkr... -08-23 14:21:37 sgenlpux_conversion: Add index(es) on table rpu... -08-23 14:21:37 sgenlpux_conversion: Add index(es) on table rsb... -08-23 14:21:37 sgenlpux_conversion: Add index(es) on table ruf... -08-23 14:21:38 sgenlpux_conversion: Add index(es) on table rut... -08-23 14:21:38 sgenlpux_conversion: Add index(es) on table rxu... -08-23 14:21:38 sgenlpux_conversion: Custom Processing Point 3, Post Schema Load -08-23 14:21:39 sgenlpux_conversion: Custom 3: rename_v50b -08-23 14:21:39 sgenlpux_conversion: Executing s50blpux_proc3rename.sql -08-23 14:21:40 sgenlpux_conversion: Rebuilding all views -08-23 14:21:57 sgenlpux_conversion: Refreshing stored procedures and triggers -08-23 14:21:58 db_drop_code: Drop SQL code from prod for test -08-23 14:21:58 db_drop_code: Running commands as DBO, lpr_test -08-23 14:27:43 db_drop_code: End -08-23 14:27:43 db_load_code: Load SQL code in prod for test -08-23 14:27:43 db_load_code: Running commands as DBO, lpr_test Xproc: aacompare(dates) lessee(add_remove) mp(altleasesum) ar(dtl) chk(upd) mjc(convert) rase(dbaconv_ras) Xproc: related(del_app) upd(drawdown_clnt) ext(ela_asset) ext(ela_codes) hist(ela) ext(ela_les) ext1(ela_lse) Xproc: ext2(ela_lse) ext3(ela_lse) ext4(ela_lse) ext5(ela_lse) ext6(ela_lse) ext(ela_pcro) ext(ela_sales) Xproc: del(eop_ral) gl(conversion) update1(gl_note) gl(update1) gl(update2) init(codes) keychng(upd) Xproc: mp(leasesum) lxproc(misc) mp(mdeleter) mja(insert) mjc(insert) mjl(insert) upd(mjl_mwc) Xproc: delq(mwc) update(mwc_delq) mwc(excl) mwc(insert) delete(mwc_mjc) transfer(mwc_mjc) delete(mwc_mjl) Xproc: move(mwc) qry(mwc_opr) prev(mwc_proc) update(mwc_q) mwc(query) mwc(update) mwi(insert) Xproc: delete(mwi_mjl) qry(mwi_opr) mwk(insert) delete(mwk_mja) qry(mwk_opr) mwm(insert) delete(mwm_mjl) Xproc: qry(mwm_opr) move(mwr) prev(mwr_proc) mwr(qry) mwr(update) mxd(upd) mwc(non_delq) Xproc: note(get) mp(nxtnum) mp(outsassmt) mp(outsinv) upd(port_status) mp(prefetch) raa(gen) Xproc: rab(gen) rac(gen) rad(gen) radr(gen) raf(gen) rag(gen) rai(gen) Xproc: raia(gen) ral(gen) rale(gen) rap(der) rap(gen) rapa(gen) rapd(gen) Xproc: raph(gen) rapp(gen) rapr(gen) raps(gen) raq(gen) raqc(gen) raqu(gen) Xproc: rar(gen) l19(rar_k0) rarb(gen) ras(gen) rase(gen) rau(gen) rax(gen) Xproc: raxp(gen) raxr(gen) rba(gen) rbc(gen) rbd(gen) rbi(gen) rbk(gen) Xproc: rbl(gen) rblt(gen) rbp(gen) rbr(gen) rbs(gen) rca(gen) rcc(conversion) Xproc: rcc(gen) rcd(gen) rce(gen) rcf(gen) rcfa(gen) rcfb(gen) rcg(gen) Xproc: rcga(gen) rcgb(gen) rcgf(gen) rcgg(gen) rcgl(gen) rcgu(gen) rcgv(gen) Xproc: rcgw(gen) rcgx(gen) rcgy(gen) rcgz(gen) rch(gen) rck(gen) l13(rck_k0) Xproc: rco(gen) rcp(gen) rcr(gen) rcs(gen) rcu(gen) rcx(gen) l9(rcx_k1) Xproc: rdc(gen) rdcd(gen) rdf(gen) rdg(gen) rdh(gen) rdl(gen) rdm(gen) Xproc: rdmi(gen) rdq(gen) rdr(gen) rdrp(gen) rdrq(gen) rdt(gen) rdu(gen) Xproc: rep(gen) repe(gen) status(repo_acct) req(gen) l19(req_k0) l10(req_k5) reqa(gen) Xproc: reqc(gen) requ(gen) rer(gen) res(gen) l10(res_k0) rex(gen) rfa(gen) Xproc: rfl(gen) rfs(gen) rfu(gen) rfx(gen) rgc(gen) l10(rgc_k0) rgg(gen) Xproc: rgl(gen) rglc(gen) rgr(gen) rha(gen) l19(rha_k0) rhab(gen) rhe(gen) Xproc: rhh(gen) rhl(gen) rho(gen) rhp(gen) rhq(gen) rhqa(gen) rhqc(gen) Xproc: rhqu(gen) rhr(gen) rhs(gen) rhsa(gen) rhsb(gen) rhsc(gen) rhsp(gen) Xproc: rhsr(gen) rhss(gen) rht(gen) rhx(gen) rhy(gen) rid(gen) rig(gen) Xproc: l9(rig_k0) rin(gen) rip(gen) ris(gen) l10(ris_k1) l18(ris_k1) rkp(gen) Xproc: rkr(gen) rle(gen) rlec(gen) rlh(gen) rli(gen) rll(gen) rlo(gen) Xproc: rlr(gen) range(rls_dles) rls(gen) l9(rls_k6) range(rls_lse) rlsa(gen) rlsb(gen) Xproc: rlsc(gen) rlsp(gen) rlsr(gen) rlss(gen) rlt(gen) rmf(gen) rmfp(gen) Xproc: rmp(gen) rmt(gen) rna(gen) rnc(gen) rnh(gen) rnl(gen) rnm(gen) Xproc: rno(gen) rnon(gen) rnp(gen) rns(gen) rnt(gen) roa(gen) rop(gen) Xproc: rpa(gen) rpar(gen) rpay(gen) rpaz(gen) rpc(gen) l10(rpc_k0) rpd(gen) Xproc: rpf(gen) rpfa(gen) rph(gen) l16(rph_k1) rpha(gen) rpi(gen) rpl(gen) Xproc: rpm(gen) l10(rpm_k1) rpn(gen) l10(rpn_k1) rpo(gen) rpp(gen) rpr(gen) Xproc: rps(gen) rpsp(gen) rpu(gen) rpw(gen) rpx(gen) rpy(gen) rpz(gen) Xproc: rqm(gen) rqp(gen) rqs(gen) rqt(gen) rqtr(gen) rqu(gen) rqy(gen) Xproc: rqz(gen) rrf(gen) rrg(gen) rrgc(gen) rrp(gen) rrpf(gen) rrr(gen) Xproc: rrrp(gen) rrrq(gen) rru(gen) rsa(gen) rsb(gen) rsc(gen) rsf(gen) Xproc: rsfs(gen) rsh(gen) rsp(gen) rsq(gen) rsr(gen) l10(rsr_k1) rst(gen) Xproc: rsu(gen) l10(rsu_k1) rtd(gen) rtl(gen) l10(rtl_k0) rtm(gen) rtmn(gen) Xproc: rtn(gen) rtp(gen) l10(rtp_k1) rtr(gen) l24(rtr_k0) l30(rtr_k0) rtr(range) Xproc: rtx(gen) l19(rtx_k0) rty(gen) rtz(gen) rua(gen) rub(gen) rubt(gen) Xproc: ruc(gen) rud(gen) rue(gen) ruet(gen) ruf(gen) rug(gen) ruh(gen) Xproc: ruht(gen) ruj(gen) ruk(gen) rukt(gen) rum(gen) run(gen) runt(gen) Xproc: ruo(gen) ruq(gen) ruqt(gen) rur(gen) rus(gen) rust(gen) rut(gen) Xproc: rvd(gen) rwt(gen) rxf(gen) rxp(gen) rxu(gen) ryr(gen) rza(gen) Xproc: rzg(gen) rzga(gen) rzp(gen) rzq(gen) rzu(gen) mp(srchclnt) mp(srchvin) Xproc: mp(u0112) u0201(delete) u0203(delete) u0205(delete) u0216(delete) u0217(delete) u0219(delete) Xproc: u0220(delete) u0229(delete) u0411(1) mp(u0463) mp(u0488) mp(u1101lx1) mp(u1101lx1b) Xproc: mp(u1101lx2) mp(u1111) upd(allowed) update(passwd) archv(vertex_rlo) rnm(vertex_rlo) rlo(vertex) Xproc: mt(mcml) mt(mcmu) mt(mja) mt(mjc) mt(mjl) mt(rad) mt(raf) Xproc: mt(rag) mt(rai) mt(ral) mt(rap) mt(raq) mt(rar) mt(ras) Xproc: mt(rau) mt(rax) mt(rbk) mt(rbl) mt(rca) mt(rcc) mt(rce) Xproc: mt(rcf) mt(rcg) mt(rcp) mt(rcu) mt(rcx) mt(rdc) mt(rdm) Xproc: mt(rdq) mt(rdr) mt(rep) mt(req) mt(rfs) mt(rgl) mt(rgr) Xproc: mt(rha) mt(rhl) mt(rhq) mt(rhs) mt(rin) mt(rip) mt(rkp) Xproc: mt(rle) mt(rlo) mt(rlr) mt(rls) mt(rmf) mt(rmp) mt(rna) Xproc: mt(rnm) mt(rno) mt(rpa) mt(rpar) mt(rpf) mt(rph) mt(rpr) Xproc: mt(rps) mt(rqt) mt(rqu) mt(rrg) mt(rrp) mt(rrr) mt(rsc) Xproc: mt(rsf) mt(rst) mt(rtm) mt(rub) mt(ruc) mt(rue) mt(ruh) Xproc: mt(ruk) mt(run) mt(ruq) mt(rus) mt(rvd) mt(rzg) -08-23 14:42:31 db_load_code: Loaded 454 source files -08-23 14:42:32 db_load_code: End -08-23 14:42:32 sgenlpux_conversion: Setting DB Security -08-23 14:42:32 db_set_security: Set db security in prod for test -08-23 14:42:32 db_set_security: Running commands as lpr_test -08-23 14:42:47 db_set_security: End -08-23 14:42:47 sgenlpux_conversion: Setting default values in rcg... gencon: Start: /08/23 14:42:48 rcg fill 1 row updated gencon: End: /08/23 14:42:48 -08-23 14:42:48 sgenlpux_conversion: Setting default values in rfs... gencon: Start: /08/23 14:42:48 rfs fill 3 rows updated gencon: End: /08/23 14:42:48 -08-23 14:42:48 sgenlpux_conversion: Start calculated SQL updates. -08-23 14:42:48 sgenlpux_conversion: Executing s50blpux_sybmwa.sql -08-23 14:42:49 sgenlpux_conversion: Executing s50blpux_sybmxd.sql -08-23 14:42:49 sgenlpux_conversion: Executing s50blpux_sybras.sql -08-23 14:42:50 sgenlpux_conversion: Executing s50blpux_sybrcc.sql -08-23 14:42:51 sgenlpux_conversion: Executing s50blpux_sybrcgb.sql -08-23 14:42:52 sgenlpux_conversion: Executing s50blpux_sybrdu.sql -08-23 14:42:52 sgenlpux_conversion: Executing s50blpux_sybrpu.sql -08-23 14:42:52 sgenlpux_conversion: Executing s50blpux_sybruf.sql -08-23 14:42:53 sgenlpux_conversion: Executing s50blpux_sybrut.sql -08-23 14:42:53 sgenlpux_conversion: Executing s50blpux_sybrxu.sql -08-23 14:42:54 sgenlpux_conversion: Add new G/L accounts to database -08-23 14:42:54 sgenlpux_conversion: Executing s50blpux_glcombo.sql -08-23 14:42:58 db_load_bcp: Start: Load /opt/ship/shiptest//env/test/dsets/seed/msg.bcp into (test)prod.msg -08-23 14:42:58 db_load_bcp: Running commands as DBO: lpr_test * * * Current table contents will be deleted. * * * -08-23 14:42:59 db_load_bcp: Truncating msg table in database prod... -08-23 14:42:59 db_load_bcp: Loading bcp file into database prod... -08-23 14:43:00 db_load_bcp: Turning on fast bcp option... -08-23 14:43:03 db_load_bcp: bcp'ing in msg ... -08-23 14:43:05 db_load_bcp: Fast bcp option has been turned off. -08-23 14:43:05 db_load_bcp: End Load complete; check /opt/ship/shiptest//log/test.log for any errors -08-23 14:43:06 db_load_bcp: Start: Load /opt/ship/shiptest//env/test/dsets/seed/rcr.bcp into (test)prod.rcr -08-23 14:43:06 db_load_bcp: Running commands as DBO: lpr_test * * * Current table contents will be deleted. * * * -08-23 14:43:06 db_load_bcp: Truncating rcr table in database prod... -08-23 14:43:07 db_load_bcp: Loading bcp file into database prod... -08-23 14:43:07 db_load_bcp: Turning on fast bcp option... -08-23 14:43:07 db_load_bcp: bcp'ing in rcr ... -08-23 14:43:09 db_load_bcp: Fast bcp option has been turned off. -08-23 14:43:09 db_load_bcp: End Load complete; check /opt/ship/shiptest//log/test.log for any errors -08-23 14:43:09 sgenlpux_conversion: Initializing mxd... -08-23 14:43:11 sgenlpux_conversion: prod already has fastbcp set to false -08-23 14:43:11 sgenlpux_conversion: 24 task groups selected for this conversion -08-23 14:43:11 sgenlpux_conversion: 72 items attempted in this conversion -08-23 14:43:11 sgenlpux_conversion: 0 item failures recorded in this conversion -08-23 14:43:11 sgenlpux_conversion: End
Terminal emulation: you must use one of the supported terminal types. Refer to the Terminal Emulation section of the document System Requirements for more information.
Sybase Only: Updating Database Statistics
After converting the database, you may need to use the LeasePak script db_update_statistics. For more information on when to run this script, refer to the Sybase documentation on update statistics or contact your MSI representative.
To update the statistics
- Log on the server as msidba
- change to the $top/env/environment/bin directory, where environment is the environment whose database you are converting
- Run db_update_statistics
db_update_statistics environment-name [dbo-password]
where environment-name is the name of the environment whose database you are converting and dbo-password is the database owner password.
Terminal emulation: you must use one of the supported terminal types. Refer to the Terminal Emulation section of the document System Requirements for more information.
LeasePak Client Upgrade
Follow the procedures in the Upgrade and Conversion section of LeasePak Client to upgrade the LeasePak client software.
Old Release Removal
Once the upgrade and conversion are complete, you can remove the directories and contents of the old LeasePak and Sector7 releases. Also remove obsolete listings in the /etc/services, init.d, rc?.d, and inetd (or xinetd for Linux) directories.
This completes the upgrade and conversion
to LeasePak .
Updating LeasePak
Complete this section if you are currently running a version of LeasePak .
User Processes
Notify users in advance that the server will be unavailable. At the scheduled start time for the upgrade, use the following steps to stop any remaining user processes
- Log on the server as root
- Use the ps command to list LeasePak drivers running on the server
ps -ef | grep lpa
This not only lists instances of the main LeasePak program lpadriver.exe, but also lists other LeasePak processes, such as the End of Period program lpaeopdrvr.exe.
- If any of these processes need to be stopped, use the kill command
kill id
where id is the process id number.
- Sybase only: list (and stop, if needed) any
remaining processes within Sybase
- Start isql in 132-column mode
isql -Usa -w132
- Use sp_who to list user processes. The terminal will display something similar to the following
fid spid status loginame ... dbname --- ---- ----------- -------- ---------- 0 1 running sa master 0 7 recv sleep ernesto production
- If any of these processes need to be stopped, use the kill command
kill spid
where spid is the process id number.
- Start isql in 132-column mode
End of Period
Run End of Period for all portfolios in all environments you are upgrading. After End of Period is finished, do not make changes to any of the databases. You may also want to limit user access to the server and DBMS server once End of Period is complete.
Sector7 Queues
Log on the server as msiadmin and stop all Sector7 queues
dcl -n $S7DIR/com/stop_qmgr.com
Server Backup
Perform either a full or incremental server backup as needed.
LeasePak Installation
Complete the following sections from LeasePak Server Preparation and Installation
When updating from a previous installation of LeasePak , you may want to use one of the following options with setup: -b, -s7, or -l. See the setup program instructions for more information.
Updating LeasePak Databases
If you installed the new release of LeasePak using the -b option or no options (which includes all by default), you will need to update your LeasePak Databases.
Log on the server as msidba and run the following three scripts in sequence:
- db_drop_code environment-name [dbo-password]
- db_load_code environment-name [dbo-password]
- db_set_security environment-name [dbo-password]
where environment-name is the name of the environment whose database you are converting and dbo-password is the database owner password.
Sybase only: you may also need to run db_update_statistics.
For more information on when to run this script, refer to the Sybase documentation on update statistics or contact your MSI
representative.
To update the statistics
- Log on the server as msidba
- change to the $top/env/environment/bin directory, where environment is the environment whose database you are converting
- Run db_update_statistics
db_update_statistics environment-name [dbo-password]
where environment-name is the name of the environment whose database you are converting and dbo-password is the database owner password.
Terminal emulation: you must use one of the supported terminal types. Refer to the Terminal Emulation section of the document System Requirements for more information.
Sector7 Queues
Log on the server as msiadmin and restart all Sector7 queues
dcl -n $S7DIR/com/start_qmgr.com
dcl -n $S7DIR/com/start_queues.com
If needed, continue with the document
LeasePak Server Configration and Maintenance.
LeasePak System Administration Guide
©
by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.