©2010 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice

Upgrading to HP Asset Manager from Asset Center: tips, tricks, and lessons learned

Victor Adao, Kaiser Permanente

Russell Parker, Minerva Enterprises

Minerva Enterprises

Consulting firm focused on

IT Asset / Financial / Service

and Software Management

Kaiser PermanenteCare Delivery

36million

hospitals

54thousand

physicians and nurses

36

doctor office visits in 2009

431 medical office buildings

Kaiser PermanenteAncillary

prescriptions filled129million

lab tests performed

imaging studies performed

61million

8million

Kaiser PermanenteHealth Plan

8.6million

members across ten states

and the District of Columbia

ranked Medicare health plan

in the nation

42billion

revenue in 2009

#1

Kaiser Permanente’sHistory with AssetCenter

• Using AssetCenter for almost a decade

– Initially deployed AC 3.6 in 2000

–Reimplemented with AC 4.2 in 2003

–Upgraded to AC 4.4.1 in 2005

–Upgraded to AM 5.20 in 2010

Kaiser Permanente’sIT Computing Portfolio

• 300,000 Workstations and Desktops

• 100,000 Laptops and Notebooks

• 25,000 Servers and 1000 Racks

• 2,000,000+ Software Installations

Kaiser Permanente’sAdditional IT Portfolio

• 350,000 Monitors and Displays

• 70,000 Network and Telecom Devices

• 6,000 Leases and Maintenance Contracts

• 120,000 Printers and Other Devices

AM 5.20 Upgrade Benefits

• Coming EOL for AssetCenter 4.4

• New functionality in Asset Manager 5.20

– Eliminate old customizations now standard

– Performance Enhancements

– Support for DB2 9.x and WebSphere 5.x

– Business Services and enhanced SW Asset Module

– New Web Services based client

Infrastructure Technology

Not just an AssetCenter Upgrade…

• DB2 8.2 to DB2 9.1

• WebSphere 5.x to WebSphere 6.x

• AssetCenter 4.4.1 to Asset Manager 5.20

• Connect-It 3.5 to Connect-It 3.91

• Tivoli Inventory to BigFix Discovery

Savings from Upgrade

• Eliminated IBM maintenance costs

• Eliminated hardware costs legacy versions

• Newer shared infrastructure environments

• Aligned to Green initiatives

Organization Challenges

• SOX Separation of Duties Considerations

• Shared Infrastructure

• Siloed Functional Areas

– Application Administration

– Database Administration

– System Administration

• ~400 distributed users across North America

Connect-It Lessons Learned

• AM 5.20 Requires a minimum of CIT 3.91

• Lots of subtle differences between 3.5 & 3.9

– Could not just be opened in CIT 3.91 and save

– Unicode Character set

– API Behavior Changes

– More stringent Integrity checks in 3.9

• Connect-It effort was about six man-months

Pre-Upgrade Database Cleanup

• History Records (amHistory)

• Database Options (amOption)

• Software Installations (amSoftInstall)

• Inventoried Models (amInventModel)

• Features (amFeature and amFV*)

• User preferences (amSysConfig)

• Workflow Instances (amWfInstance)

Pre-Upgrade Database Cleanup

• History – 33 Million amHistory Records

– Determine and Delete unneeded History

– Reduced History by ~10 Million records

– Added functionality to archive History

• Database Options – amOption Records

– Delete all old OAA based AC4 Web records

– Delete OPTSECTION Like 'person%';

– Delete OPTENTRY Like 'e_%‘ or 'userpref%';

Pre-Upgrade Database Cleanup

• Purge Software Installations

– Delete all Software Installation records from amSoftInstall and amPortfolio via DB2 directly after reviewing process with HP AM Support/Dev

– Back out AC4 Compact SW Installs Whitepaper

– Switched Discovery Source from TIM to BigFix

• Inventoried Modes (amInventModel)

– Purge old Tivoli Inventory Manager mappings

Pre-Upgrade Cleanup in AC 4.4

• Features (amFeatures/amFV*)

– Identity and Purge unneeded Features

• User Preferences (amSysConfig)

– Delete Records where CFGSECTION Like 'User%

• Workflow Instances

– Purge amWfOccurEvent

– Purge amWfWorkItem

– Purge amWfInstance

AC4.4 Database Preparation

• Drop external Views and Indexes

• Update fields which had a default = NULL

to have a value of “” or 0

• Drop and Reorg amSoftInstall definitions

• Rename Tables with long names and “_” ’s

Apply AC4.4 Pre-Migration DBB

• Remove Customization for Compact Software Installations (from HP Whitepaper)

• Remove other Customization now OOB

• Remove “Sys” from all Sceen and View names

• Added “KP” Screen Set to all Custom Screen

RDBMS Changes

• Take a Cold Backup of the Database

• New Table Spaces for Indexes, Data and LOBs

• Changed to 8K Pages from 4K pages

• Make sure DBA’s allocate enough space!

• Optimization to use Sequences not amCounter

• Delete objects not in the DBB

– Database views, Indexes…etc

AC 4.4.1 to AM 5.20 Migration

• Take a another Cold Backup of the Database

• Use AM 5.20 Application Designer

– Must have a connection with No Owner

– Must be on > Win 2000 because of AutoPass

• Execute Migration Upgrade Import Script

Apply Post Migration SQL/DBB

• Alter Tables to add or rename old Fields and eliminate “_”’s from the SQLNames.

• Reduce SQLNames to 18 characters

• Create new Tables

• Run SQL to set initial values on new fields

• Create Triggers

• Created new Indexes

• Create new DB Views

Copy Feature Data to Fields

• Some Features had valid data

–Used direct SQL to copy Feature Values

–Used direct SQL to delete Feature Values

–Delete Features manually from Client

–Validate SQL Scripts with HP Support

Validate Database Views/Rights

• Confirm Existence of Database Views

• Perform Grants on various Objects

–New or Altered Tables

– Stored Procedures

– Sequences

AM and DB2 Client Settings

• Settings for AMDB.INI File

– Added “FetchingArraySize=1000”

– Added “ImportCounterCache=1”

• Left Outer Join Registry fix for Crystal Reports

• ADBC Driver Registry fix

• Add “ReOpt=3” to DBCLI.INI file

Post-Upgrade Data Changes

• Removing the “sys” from “SZ_Option” field

• Migrate Search Wizards to Views

– Rename View to the name of the Table

– Delete the Search Wizard

• Add “KP” screen set after “Views” entry

Post-Upgrade Data Changes (cont)

• Update the amNature “computer type” field

• Missing constraints in AC allowed duplicated

• Change from User Profile to User Roles

• Populate all Functional Domain links

• Reset Database Options (Ex: PasswordLib)

New or Updated Workflows

• Duplicate Workflow Bug Workaround– AM5.20 does not duplicate Workflows properly

• Updated/Optimized AC4.4 Workflows– Took opportunity to assess existing Workflows

• Newly created Workflows for AM 5.20– Took the opportunity to add new functionality

– Combined and/or eliminated several

New or Updated Wizards

• Set/Reset User Account Wizard– Changes needed due to new User Roles

• Password Wizard and Script Library

• Updated/Optimized AC4.4 Wizards– Took opportunity to assess existing Wizards

– Combined and/or eliminated several

Final Thoughts

• You can never plan enough

• You can never test enough

• Use Support and Get Help

Go For It!

Contact Information• Victor Adao, Business Consultant Specialist

Kaiser Permanente IT IMG: Asset Management ProgramOffice: 916-251-7008Email: victor.adao@kp.orgWeb: https://www.kaiserpermanente.org/

• Russell Parker, Founding PartnerMinerva EnterprisesOffice: 858-663-9413Email: Russ.Parker@MinervaE.comWeb: http://www.MinervaE.com/

Come see us at booth 308

32 ©2010 Hewlett-Packard Development Company, L.P.

To learn more on this topic, and to connect with your peers after

the conference, visit the HP Software Solutions Community:

www.hp.com/go/swcommunity