*********** Highlights ******************
- SA 8.0 coming Q2 2001 (tools 8.1)
- Monthly Service packs are the new PUUF delivery method for SA. will continue individual
- Found potential work around for MassChange single submission problem - Software Armada consulting developed it.
- UCF has free code to auto-send SQR output (dat, list, log) to appropriate email addresses by OperID via modifications and enhancements to the PRCS scripts
- The reverser is now available for purchase alone - MUST GET THIS NOW!!! Use also for reporting, warehouse, development, impact analysis, SQR debugging
- Provide free Internet access (outside NU facilities) to our students via a partnership with a "Free Internet" provider - NU Portal and each student has her own personal page, phone service,  a la Yahoo etc.
- Technical presentation files at ftp://137.148.200.55
- Multilanguage web support for international educational market in PTools 8.0 available now
- NU Needs to add contact person information to the SIG list
- In tools 8: Addition of PSPSWDLST gives you the option of: Expiring Passwords, Minimum Length, Special Character/numerals required (Works in harmony with PSOPRDEFN)
- PS Continues to use VistaPlus (Quest Software) for output distribution consulting engagements!
*********** Highlights ******************

Sunday 3/12/00
==============
# D3 - Technical Meet the Experts
- 20 Tech Sessions presented by PS emps
- Business process tool no longer used for HTML Access in 8.x, AppDesigner support for "Pages" instead of panels.
- 8.x->decentralized security, LDAP support, sec. auditability built-in
- 8.x->Security built as a PT 8.x panel app (customizable)
- 8.x->HTML Access uses JSP, Servlets, Apache+Jserve for in-house testing. Also testing with IIS+Jrun
- 8.x->New Process Scheduler API, continue to recommend AutoSys, etc., for shops with complex batch job requirements (e.g. most of us!!!)
- 8.x->AppEngine and Process Scheduler are now C++ Apps
- 8.x->UDB/DB2 for NT will be supported
- Partnership with Pilot for ASP clients
- 8.x->No version control support yet (was planned for 8), but full upgrade support for all repository objects (12 new object types)!!!?. Project now can contain external file references (e.g., can associate files like NEU's RTS!).
- Asked if any additional AppServe monitoring/control-> Answ: No, continue to rely on 3rd party products such as FogLight
- Q. How to force client refreshes when app changes. A. Use the dbrefrehs script
- MassChange will not be upgraded in 8.x, prefer to use AppEngine for batch jobs.
- New HRSA benchmarks should be available on the CC in April'00.
 

Monday 3/13/00
==============

# Opening Keynote - Craig Conway
- Conf. was headed by Marla Thomas
- less than 10 to 427 worldwide since 94
- 40% community colleges (9 or less months)
- 40% year Univ.
- Northwestern using 1st HTML access product 200K hits/day, 250 concurrent users
- Problems are quality, service and performance. Response: #1 quality, #2 implementation scheds and #2 accountability
- Changes: re-org development new manager in charge for all aspects of the product, Liz Dietz. 100% QA growth in last 7 months + new QA programs - incidents to GSC down and more are closed - Extended testing - Performance:
PS and clients, meet on Jan. work with Northwestern etc. to replicate PS on Oracle to tune performance. Field offices have HE dedicated team (per geo area) -
- To improve implementations: strengthen partnerships and PS PSG's expanded for HE (2000K) to include development and methodologies and tools. Six ele: Skilled Prj manager, accurate conversion and testing of data, appropriate
training, appropriate staffing, expectations, ownership
- Future: eBusiness for HE for new revenue, more timely releases, QA, service
- 25% compensation bonus tied to service evaluation from customer
- Peter Gasner - gen mangr PeopleTools

#1102 - Upgrade Tips and techniques, C. Dahlin - Boise State U. (7.6)
- Upgrade lab used
- Planning Prep (before freeze)
- Technical phase (physical upgrade)
- Application Phase
- TIPS - October 1st start
- Start with AUD/Vanilla then Development and the others
- Use fastest PC possible, static IP, local install (not on file server)
- downloaded all PUUFs first
- trace off
- upgrade require high number of locks
- pre ddaudit, sysaudit, alter audit
- pre ddldefparms match reality ( Oracle?)
- ensure available space for db
- freeze PTools - queries, trees, oper security
- turn off change control (only on dev)
- require large rollback segments so can do parallel runs
- run compare reports on server
- update statistics frequently
- compare report add -KEEP to SQR
- color coding scheme for key, overwrite, etc.
- training functional/tech team using the compare reports
- produce the reports for vanilla and for keep custom
- re-document code based on decisions
- accept PS even will not use and then drop if needed
- mod scripts so do the change and set values in one pass
- turn off archiving
- do data conversion for all products in db, even if not is use
- continue applying PUUFs as they become available
- unit test by developers
- functional identify data setups, query changes, security changes
- customized MCs, revert to vanilla use NEU name for all customized
- Crystal - manual all test
- requires 100% of availability of functional experts and analysts
- purge message log tables
- if customized export/import: AE, MCs, queries, setup data, operator profiles, security
- run upgcount.sqr before and after
- task sheet in detail required
- keep all logs of all sqrs, dms's, sql
- pick and enforce a freeze date (use single user for ongoing dev proto/spec deve)
- 70+ hours for the final move to prod (it took 48 hrs at the end), had 5-10 in HR, and 50 in SA, plus reports/queries, enhancements OK, did 5 test moves (last at the lab)
- track times for each step in detail
- track rec counts to explain long run upg jobs
- don't run SQR & DMS jobs more than once on same DB
- backup at points before structural changes
- tune tune tune
- try to run SQLs in native SQL tool rather than in DMS
- on compare reports - keep vanilla & keep custom
- ( 7.0 - 7.6 65K objects changes, 4-6months
- Presentation on the web site for the Sig
- use automated regression testing wherever possible
- test all scripts (for Cartesian joins) ahead as early as possible
- use the upgraded db to source the others dbs
- 10-12 tech people, plus 6 dedicated during their tasks, plus others from time to time for testing
- presentations files at http://137.148.200.55
 

# 1104 - Deploying and Maintaining PS clients, J. Bartnick - U. of Oklahoma
- 2800 students in health sciences, 200 employees
- avoid touching the clients when need to update/upgrade
- Compag Proliant file servers
- 590 users + 308 HR
- Win NT & WIn 9x
- Hybrid 3-tier mod.
- separate by application version folders, e.g., HE 7.5 with all for it
- separate distribution share
- separate setup and batch file dirs for platform, eg. NT vs 9x
- initial config using demo sets and then add more (use -setup & -install flags in configurator)
- use regedit/s ...
- call crystal setup as provided from cwr6x dir and the same for SQA robot
- have not been able to set MACHINE variables for SQL connectivity settings (how does ATS do it?)
 

# 1106 Migration and Environment Panel - Bob Tala - Cornell U. et al.
- use NT resource kit Scopy to synchronize NT file systems
- using a reporting environment
- using Hummingbird Exceed & Maestro, NFS Solo - research DoubleTake
- Repeated a number of points from sessions #1104
- Slow-Client: an antivirus program slows PS client because of access rights checking overhead
- Crystal reports migrations keep OperID info. and that's a problem
- nVision server runs leaves the excel on
- Signed approvals required for migrations to prod
- tech. leads track and perform migrations to non-prod environments
- Georgia centralized 32 prod databases for all their campuses (same for app server), distributed file servers, about 94 db's now during implementation, 5 DBAs, use BMC's Patrol,
- use InstaShield to install file servers for PS and PS client
- looking at EMC's BVC's and hot backup later
- Using Samba for file servers for PS environments
- Cornell had 41 environments, now at 9 with just HR
- use CVS 1.1 for version control, vantive for requests, CPSS tried but did not work from Anderson Consulting to produce impact lists
 

# 1108 - FTP and the Process Scheduler - Bradley Smith - U. of Central Florida
- PS 7.5x, Sun E5500, Oracle
- give access to log/trace/etc files to user/developers
- modify: prcs_sqr, prcs_bat and prcs_stf (on the server) - run multiple letter gen
- OperDI same as email ID
- e.g., OPRID@xxx.xxx.xx
- email must be able to handle MIME client
- output files must be named like the SQL lis files (use instance number)
- cclettergen needs to be modified to route output file
- create -KEEP (ie SPF produced)
- for prcs_stf: check_and_build_output() add code a the bottom of the function
- for prcs_sqr: code to cap OperID, db instance and proc instance, send mail code
- prcs_bat: exit point for send mail, if tracing on server, will email trace file
- for SQR comm line arguments (run contrl rec), or from process sched, use only runctrl.
- for interface programs: legacy-unix, import synchronization. Done using two tables in deve datab capture local/remote site information
- locate and delete
- web site to get this CF_FTP.DAT
- modified files must be backed up because get overwritten when backup
- www.pegasus.cc.ucf.edu/~brad
- need a UNIX/AIX shell script programmer for this - needed anyway to support AutoSys
- would not need this if using VistaPlus
- now does one-to-one, who runs it on the server gets it all via email
- register SPF file types on desktop and use viewer to view, can print
- based on "_<instance#>.", it can handle multiple lis output files
 

# 1110 - What db Environments are Doing - Larry Strickland - Ginger Tendl
- Doing 7.5 upgrade - Doing Payroll/HR (Oracle), HP servers, physical 3-tier, NT as app servers
- Lack of info from process sched & app server
- http://www.spjc.edu/AC/AIS
- Developed a html tool to monitor all environments - cross platforms (on browser)
- pages for each db, app server, and log/lis/trace
- Is Process Shed/App Server working? Who is using?
- done with html, perl, cgi, ftp, telnet
- use the pclt tuxedo line command
 
 

Tue 3/14/00
===========
# Keynote - the tech chief from PS
- The analogy of the railroad influence and the internet influence on our way of life
- His mom Ruby, initially scared of the web, now has takes a cut of book$ her friends buy through her web site from Amazon
- Get the NewYork Times from the internet to his Pilot for free every morning
- Reuter, founded in 1871, spawned Tibco on their own recently
- The first step the new CEO of EggHead did was to close all stores and become a 100% web based business - which University president will go to his board and say "the first thing I want to do is close down all our classrooms!"
- It's about connecting to students, educators, vendors, personally and developing new services and products to them i.e., NU should partner with "free Inet" provider to get free internet access to students outside NU, instead of trying to build an infrastructure to do that using modem banks!
 

# 1112 PeopleSoft Web Strategy - David Giammona - PeopleSoft
- Goals are: 100% internet , open integration, business intelligence, rapid and flexible .deployment.
- EPM products released in Dec'99 using PeopleTools 8.0
- Tools 8.1 will come with HRSA product
- PDU will be available six months prior release date
- Integration tools: app messaging, component interfaces - synch, business interlinks (plug-ins), application engine, directory server (LDAP)
- Business intelligence: internet reporting, analytical app support
- RAD: upgrade wizard, link to PS site for per client needs only - no searching what applies to each site
- Pure HTML based for fast low bandwidth response
- JavaServelets (JSP) feeds pages to web server from the AppServer, e.g., app server process will be generation HTML pages (javascript in the HTML)
- AppDesigner will be a web app designer, project based, multilingual, support for 1k'S of concurrent users
- Only the AppServer connect to the db, now called "PeopleSoft Internet Server" capable to integrate to wireless systems and micro-web connections
- HTML/XML/UML based transaction now supported
- Portal allow merchant connections: Open Integration Framework and ... Profile management, Relevance (role based), Navigation (entry point to other PS apps), Search Engine, Content management for both PS and non-PS (separate
license)
- all page content is language sensitive
- HTML exit (custom) in the Designer
- Multilanguage web support for international educational market in 8.0 now
- Collapsible sections and VCR type navigation row level navigation
- also can use browser navigation
- changes are done to the panel in AppDesigner, and the changes are immediately available because AppServer reads them from the tools repository
- All tools, other than the designer, are internet products
- HTML Access not supported in 8.0
- Integration: component (realtime synch) - evolved JMAC, message based (asynch), file based (see table for in-bound vs. outbound capabilities)
- Panels renamed pages, and panel-groups renamed components, able to decide what part of components exposed to outside
- Business interlinks (to other merchants)
- AppEngine will generate XML for links, read and write files for file based
- Messaging: publish/subscribe, XML/HTTP based for app-to-app and B2B
- Used inside PS among PS apps. e.g., replicating security profiles between HR, Fin, Portal, Tree manager info send messages
- Cross publishing, apps/platforms/versions
- Message Node: created in both sides to apps with and XML message definition, channel control how the message is routed/rules/content sensitive, monitored via new message monitor
- Message is processed using PeopleCode
- Message Queues - must exist on both ends. All processed by message server and served by java servlets
- Interlinks: Component based, realtime to PS rules and data, transaction level integration, C/C++, COM & Java supported. For eMerchants into PS, 3rd party links credit card appr, shipping tracking, works across XML, HTTP, Java,
DCOM, CORBA - the BI Plugin (VB or C++), deploy it on via web
- AppEngine - fixed, delimited, XML. New file layout object. PeopleCode is the processing language. Capable to call other integration apps and all upgradable using PT upgrader
- Directory services:  authentication update/signon
- Integration with IBM's MQSeries (transaction based) for 8.1 tools

# 1114 - Evaluating System Performance Panel -  M. Dysart & J. Butler - Ohio State, Pat Knorr  - Princeton and Mike Hayes - Cleveland State

* M. Dysart - Perf & Tuning tools
- HPUX
- separate net, secu, disaster
- Need strong net eng, dba, apps knowledge
- in Unix use sar, swapinfo, ipcs, IT/O, MeassureWare, and PerfView, sam and kernel parameters
- in Oracle: orainit, V$ views, data dictionary, sqlnet params, Compuware EccoTOOLS, Oracle Enterprise Manager
- Use Citrix as front end
- Network: cisco switch config, topology, OpenView for node manag
- Use EcoSpace
- PS: data model, indexes, bad WHERE clauses
- load testing the apps
- Use Mercury Load runner
- Batch: log file monitoring (failmail to monitor)
- automatic correction
- Job sched calendars
- Conclusions: Iterative process, continuos monitoring, coop among tech roles

* P. Knorr - Monitoring and Perf tools
- 30 Oracle dbs
- Developing a production support
- products evaluation: Tivoli for Oracle Provides: Command console, sys resources, availability of db and management (table spaces, sizing, extends), stats
- PS Tuxedo and AppServer in 7.5
- OEM Oracle - change management pack to track db changes
- Unix scripts: can send copy of scripts: monitor db cache, check table space, check backups and archiver, check processes, etc.
- Using Maestro for batch job scheduling
- Other: Top, vmstat, sar
- SQLab Tuner (Oracle) explain plan easy tool

* J. Butler - App tuning ald load testing
- App tuning
- Tools 7.0, PO/AP/Inv/Asset- HPUX 20..3, Oracle 7.4
- Mercury Interactive: scripts (user) for virtual users, Top Oraclesessions to get SQL
- Oracle explain plan and
- Load testing - load Runner: record all SQL capture (break into) load panel, search, data, save
- Records timing for normal user timing, can disable to run fast
- Look for exp lines times as number of virtual users increases
- Online user testing - with think time on - batch x number of users - loops to load the db - and have then real users to evaluate performance
- Batch tuning: trace COBOL get timings and number of times run (80% of the time 1 SQL is the trouble
- For AppEngine, watch in Oracle Tops and review the SQL time
- Watch out for - full table scans, list-boxes (that returns many rows - full table scan) - Bugs in Oracle 7.3.4 (bind var) long SQL with view or binds then remove view and join the tables. Looping with SELECT repeatedly called
(see APY2010.SQR)

* M. Hayes - Tools from Foglight
- Monitoring 12 servers
- NT and Unix
- used by DBA, admins, NT admins
- Monitor: CPU load, utilization, etc.
- Graph based - Unix, AppServer
- Savant - Que Diagnostic Center: Oracle & Unix monitoring
- Lots of sample displays for the tools were shown
- For Sun could use SE and use ORCA to graph parameters (how about semaphores)
- Foglight does monitor semaphores (written by the guy that wrote SE)
- Was Rational tested?
- AIX ? $105K for 40 boxes (looked at Quest and Savant)
- Rules or Cost based? Use CHOOSE - analyze schema - cost base - but can put hints for some SQLs
- If stats are deleted for one table, then it uses tools
- Tips for tuning SQL: explain plan, full scans?, re-write to make cost go down
- Tuning a query and indexes - may alter the plans of other queries
- Foglight uses a separate server box to process data
- Any one looked at Candle & BMC's Patrol?
- Foglight get info and more that pclt & psr
- Tuxedo tuning: make sure mem management (need right semaphore info)
- Overhead of Foglight (access to V$ tables)
 

# 1116 - Configuration, Admin and Troubleshooting AppServer - Andrew Cesario
(PeopleSoft) - andrew_cesario@peoplesoft.com
- 3-tier client: can connect via SQL to db server. 3-tier to wsl & wsh using Tux
- Good slides with all the components involved in the 2 and 3 tier process - for 7.0->7.5->8.x
- QryServe in 7.5x (post 7.53) set to at least 3 for max and min ( the auto spawning not working)
- Domain Config: Good slides describing process of creating/changing configuration files.
- AppServer tracing: SQL & PeopleCode (all clients on the AppServer). Slides showing the process are good (like the training manual). Detail review of the tracing parameters. Output is in $PS_HOME/appserve/<domain>/LOGS/
- Get docs for network services from Tux. documentation form the presenter
- Trouble shooting techniques: slides with general type of problems. 99% of errors are due to database connectivity problems. Check Appserver.log, increase tracing level and check again.
- Service timeouts: slide with timeout detail about each service
- List of all the services in one slide
 - Remote call failures: slide for types and explanation (COBOL calls), also debugging procedure
- IPC resources: semaphores, shared memory, message queues: explanation of what they are documentation form the presenter Get presentation from presenter.
- Where to get more (Tuxedo, 3-tier) in the CC, in the TUX installation dirs
- List of files that the CC needs to troubleshoot AppServer problems. Typical setting for tracing to get the log file to send for support.

# 0819 - Creating Management Info form Student Data - U of Minnesota - John, Rick
- DW group 6 people (Informatica) dictionary, models, extracts
- Reporting group 6 people, business analysis, report deve, catalog manage, report publishing, server admin
- Portal Development 3 people: data mart development, portal development asp/XML, X.500 security integration, Cognos integration
- Customer support 2: Phone support, training, troubleshooting, on-site support, cummunication (coordinated with enterprise reporting)
- DB2 warehouse - student tables (old system) w/ IBM App System Reporting Tool
- Goals: run all reports off the transaction systems - went no where.
- Revised goal: warehouse, confirmed by external review, denormalized tables, use ETL tools
- Live with Crystal/SQR reports. Nightly copy of PROD  ETL to warehouse to Oracle
- Admissions - 29 tables * Student records - 12 tables plus 50 historical tables * 18 Course tables * 13 Graduate tables * 18 Fin Aid core plus 50+ historical data * Student Financial tables
- Reporting Tools: Cognos (web-based, warehouse) - Impromptu/Cube OLAP/PowerPlay * MS asp for web based data mart reports * IDEA - web-based warehouse queries * ODBC access to user-picked tools.
- Web Portals: delivery mechanism for pre-designed queries and reports * MS asp used to report off MS SQL Server 7 are pre-defined reports * IDEA web interface off Oracle data warehouse
- Future: have All data in one vendor (i.e., Oracle) * Integrate portals for one-stop service/simplified access
- Reporting is THE measure of success, i.e., not everyone uses the transaction system (e.g., "they" very politically influential)
- Strategic Consider: Appoint a data czar: enforce consistent business rules, integrate access policies * Build first for the enterprise not for the parts: build around the business processes, look for similarities in your ad-hoc
requests * Manage growth: track usage (:> web stats), e.g., 300 to 2,600 users in 15 months
- Reporting Goals: speed up development: no SQL please, join tables up front, build once, use across the enterprise * Electronic delivery: end paper shuffle, usage monitoring, decentralize scheduling,
- Other issues: training for users and developers (about 2 weeks to start as developer in Cognos dev tools), security, customer support, performance
- Table Tips: build table to support business processes, current rows: eff dt, indexing, Oracle Hints * build calculations in the tables * document tables/columns
 

# 1117 - RTS - Feedback & questions - R. Venegas
- Got a about 500 people capacity room
- About 300 attendees to my session!!!
- A member of NERCOMP interested in having this presentation for their meetings
- Had over a dozen questions during/after the presentation
- several people came over with all kinds of questions
- Umass Med School, Worcester, asked for review/feedback on their proposed "Updates & Fixes Maintenance Strategy" paper.
 
 

Wed. 3/15/00 - Liz Dietz Keynote
=========================
-180 PS emps participated in conference
- Now: shared bio data, demographic data, single identifier, multiple roles; for existing technology optimal solution
- chart showing shared data among HRSA & Fin
- Feedback: release timing issues, db operations take longer, period processing collide,
- Open Integration framework (publi/Subs, Components, Interlinks) to be use for optimal solution
- Plans - enhanced integration/consistency, eliminate physical constraints of one db for all
- Phase I HRSA 8.0 : expand HRSA to Fin integration, more API (over 400 enter integration points)
- Phase II HRSA 9: encapsulate business processes into components * separate HR and SA and Dist * a chart with what data will be left in SA, HR, FIN * use a/synch/batch * independent db operations,
- No mention of delivery dates or technical details * the Campus Community session this am will cover more detail
- Need nominations for the different committees and sub-committees
- Next conference in Orlando, March 2001 (18-21) Disney World * now called the HigherEd IUG
- Posting attending list in secure web site accessible by contact person
 

# 1121 Environments and Migrations at Cornell U. - Bob Talda
- Separate in-house stu hiring/time labor and have Kronos too
- IBM servers (AIX) and Netfinity, S70/F50/H70, Informix, SAMBA, InstaShield
- Use parallel db for tax upgrades, also separate one for test for payroll
- Recommend to use SAMBA to map drives (on an S70) better because of a single point for all file needs (easy disaster recovery)
- Keep track of setup table data as part of the object tracked for migration
- Ask for script for MassChange migration
- do not do migration online
- Use CPSS tool (Anderson Consulting) and Vantive (has change management) to post migration requests
- Supposed making changes in test and migrate into PROD. Now unload and compare to identify changes
- They publish the migration procedures * web based app in the works for tracking
- Have develop table list for small sub-set data for testing
 

# 1124 - Upgrade Panel - Richard Yantis (Texas Christian U), Teri Heaps (Brigahm
Young U), Carol Dahlin (Boise State), Wendy Showalter (Ohio State)

* TCU: Oracle 7.3.4 * TOAD (free tool for Oracle) in www.quest.com * PVCS and
tracker (version control and change request) * Use Access to track
customizations * started Fin 6->7.0 June'98-June'99 * Using Housing system from
JMU * Use IBS from Interactive Business Systems * live 7.5 * detail of 7.6
upgrade from Jun'99 to Feb'00 (from Thurs-Sun) - full day test on Monday * team:
Camb tech Partners + 2 + 5 dev + 4 users * Stay current with patches in Demos db
* involve tech and users from the beginning * when to freeze patches etc. and
when to catch up * careful not to loose ddl customizations * plan for extra dbs
needed. Use a VB app to run SQR, SQL, DataMover from a job control file (get
this) while keeping unique log names. Upgrade CAM on the upgrade room.

* BSU: Live all HRSA 7.5 April 99 * Fin 6.0 * 7.0->7.6 started Oct'98->Feb 22'00
* Tax updates 6-8 /yr, Fin 3-5, Apps every 18 mths, App Updates 1-2 yr * Tools .
* PUUFs 20-40 month

* BYU: 5.12 to 6 to 7.0 * main consideration processing time * deliver scripts
would take 30 days  and tuned to 3 days * if no data do not the conversion
script * don't use datamover if possible * run scripts in parallel * create
master scripts for (about 10 master) grouping small scripts * watch table name
changes and field changes with no data conversion * review all custom views *
identifying changes to tables (tab orders) * PC customizations freeze * take the
new functionality instead custom * developer became like Ted Kazinski * send
developers to functional training

* OHIO: Oracle, Unix, Citrix, HP, HRMS/Procurement/Fin * use a monthly bundle
implementation process * apply all PUUFs * turn off transaction log - drop
indexes * with HRSA pre-req's usually are "apply all PUUFs prior to date of this
PUUF"

* impact analysis to facilitate the UAT process of PUUFs * Use Y2K tests to test
PUUF bundles *

# Closing Plenary
- Proposals due in Sep'00 for the March'01 Confe.
- Next Conf. at Disney World Resort
 
 

# GENERAL:
- try to extract business rules using SQA to navigate & capture and script to analyze and document (look into the "search peoplecode" utility - ask for code if it is a C++ app and customize for NU + DB2 - remember that the tools tables
are defined in an access group for PSQuery - develop and test on server -
- naming standard: separate customization from enhancement to facilitate upgrade process and testing. We want to do enhancements rather than mods
- consider editing of SQR, etc. only from the server (devel) so as to avoid control characters.
- Add -KEEP to keep spf for viewer
- Review the procedure used to update RTS with migration data
- Try HRMS self service in 7.6
- Make sure that the PCD tuner has AppServer tuning experience/responsibility.
- Keep track of setup table data as part of the object tracked for migration
- Do post migrations comparison of object for quality spot checking
- consider adding auditing for setup data tracking * also consider db triggers to write out changes
- Start upgrading DB/AIX/SQR/etc required for 7.6 in preparation to 7.6
- version control all upgrade scripts
- with HRSA pre-req's usually are "apply all PUUFs prior to date of this PUUF" must do UAT on them.
- send summary of this presentation to interest parties
- Standard - use robot to load test data sets with less than 100 cases
- consider Robot for loading setup data of small size since it does not gets automatically validated when entered via the panel