Thread: AssetCenter + upgrade to DB2 version 9.5

Good Day,

We are currently using AssetCenter 4.4.0.4218. Here is our product information:

Software
Build 4218
Build date 08/03/2005
Copyright (c) 1994-2005 Peregrine Systems, Inc. All rights reserved.
This software is protected by international copyright law.
Copyright Cypress Basic Basic Scripting provided by Cypress Software Inc., Copyright 1993-2004, all rights reserved.
Copyright Sybase SQL Anywhere SYBASE SQL Runtime, Copyright (c) SYBASE, INC. 1992-5;
Portions Copyright (c) Rational Systems, Inc. 1992-4
Definition file for AssetCenter connections (System) C:\WINDOWS\amdb.ini
Definition file for AssetCenter connections (User) C:\Documents and Settings\thornung\amdb.ini
Description Peregrine AssetCenter
INI C:\Documents and Settings\user\am.ini
Language English
Mode 32-bit
Name Peregrine AssetCenter
Vendor Peregrine Systems, Inc
Version 4.4.0
Version type GA
Web address http://www.peregrine.com
System information
Build 3790
Environment Windows Server 2003
Internet Explorer 7.0.5730.13
Processor x86 Family 15 Model 4 Stepping 8, GenuineIntel
Service Pack 2
Version 5.2
mapi32.dll C:\WINDOWS\system32\mapi32.dll 1.0.2536.0 (srv03_rtm.030324-2048) (English (United States))
vim32.dll File not found
Database
AssetCenter Server MAC address
Authorization string 9URZ 32?T K5H7 KHDE ZMH4 U+W
Casual users No
Database description D:\Program Files\Peregrine\AssetCenter\gbbase.xml 223
Demonstration database Yes
Expiration date 30/04/2009
Floating users 0
Named users 10
Product licensed to Customer id: 20066816_Non-Prod-AC-441
Server IBM Database Universal Server 08.02.0009

We are needing to upgrade our DB2 version from 8 to 9.5 on a new SLES10 Linux operating system.

Which version of AssetCenter do we need to upgrade to? Should we need to upgrade? How hard would the upgrade path be?

Hi,

1. look into compatibility matrix for AC, to see what DB is supported. Remember - if you use unsupported version of anything (DB, OS, servicepack) - HP might refuse to
help you in case of problems. I am not saying they will, but it is quite a big chance for it.

2. If you need just to change the DB (and it is supported) - that should be easy. But
I have done it for Oracle or MS SQL - never for DB2, so I have no idea how it is with DB2. I think it should not be difficult.

3. If you need to upgrade the AC - then you have to look in documentation and tools
provided with AC. I have not used AC for a long time, but as far as I know, upgrade from AC 4.4 to 5.x should not be painfull. There were mostly changes in web access, not in the database level.

regards
Artur