How to migrate from Sybase to UDB 
Author Message
 How to migrate from Sybase to UDB
Hi to all,

I work in Wall Street firms many years and have lots of expertise in OS and
Sybase and did lots of migrations in OS and Sybase 10, 11 to 12.

I am interested to learn IBM DB2/UDB, could someone in this newsgroup send
me or give me some hints
1. books good on UDB
2. any good IBM db2 support web site, free is the best; Sybase support web
site is great
3. pro and con on UDB
4. compare Sybase sp_sysmon and IBM UDB tools for DBA
5. UDB system facilities ex. sp_lock, system tables

Rey Wang
www.dbmethods.com



Wed, 05 Mar 2003 08:03:10 GMT
 How to migrate from Sybase to UDB

Hi Rey,

1. You might read:

 "A complete guide to DB2 UDB ", Morgan Kaufman, Don Chamberlin.
"Understanding SQL's Stored Procedures - a complete guide to SQL/PSM" ,
Morgan Kaufmann Publishers, Author: Jim Melton

2. The IBM support, why not? The traces are more normalized than the Sybase
"stack traces", indicating the area of pb.

3. I like both. DB2 v7.1 allows you to use SQL stored procedures, identity
columns, savepoints ...

4. You can use snapshots to get counters, and tune the server.

5. in CLP, "db2 get snapshot for locks on <DBNAME>" to get locks.

Sincerely,

Jean-Marc


Quote:
>Hi to all,

>I work in Wall Street firms many years and have lots of expertise in OS and
>Sybase and did lots of migrations in OS and Sybase 10, 11 to 12.

>I am interested to learn IBM DB2/UDB, could someone in this newsgroup send
>me or give me some hints
>1. books good on UDB
>2. any good IBM db2 support web site, free is the best; Sybase support web
>site is great
>3. pro and con on UDB
>4. compare Sybase sp_sysmon and IBM UDB tools for DBA
>5. UDB system facilities ex. sp_lock, system tables

>Rey Wang
>www.dbmethods.com



Sat, 08 Mar 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Migrate IBM DB2 UDB to Sybase ASE

2. Migrating from IDS 9.21 to DB2 UDB

3. Migrating from Access97 to DB2 UDB 7.2

4. Error -902 when migrating from UDB 5.0 (OS/2) to 7.1 (Win2K)

5. migrating from UDB/NT from V5 to V7

6. migrate Sybase 11.0.1 and Sybase 11.5.1 to MS sql 6.5/7.0

7. Migrating from Sybase for Unix 4.9 to Sybase for NT 11.5

8. Migrating from Sybase for Unix 4.9 to Sybase for NT 11.5

9. Migrate Sybase SQL server from Netware NLM 4.2.2 to Sybase 10 on Sun

10. Best way to migrate Sybase 10.02 / Novell 3.12 to NT 4.0 Server / Sybase 11

11. Transfer UDB/NT table to UDB/os390 v6

12. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client


 
Powered by phpBB® Forum Software