ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » migration - question reg databases

Post new topic  Reply to topic
 migration - question reg databases « View previous topic :: View next topic » 
Author Message
mqwbiwf
PostPosted: Mon Sep 04, 2006 6:26 pm    Post subject: migration - question reg databases Reply with quote

Centurion

Joined: 21 Jul 2006
Posts: 126

hi,
we currently have db2 and are planning to go for oracle when migrated to WMB 6. Could anyone please let me know how to determine the size of the database in DB2 on AIX, so that we can have use the same size when an oracle db is created.
thank you.
Back to top
View user's profile Send private message
mqwbiwf
PostPosted: Tue Sep 05, 2006 5:57 am    Post subject: Reply with quote

Centurion

Joined: 21 Jul 2006
Posts: 126

No replies guys?
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Sep 05, 2006 5:58 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0011863.htm
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
mqwbiwf
PostPosted: Tue Sep 05, 2006 6:10 am    Post subject: Reply with quote

Centurion

Joined: 21 Jul 2006
Posts: 126

Thanks a lot Jeff.
Back to top
View user's profile Send private message
mqwbiwf
PostPosted: Thu Sep 21, 2006 12:10 pm    Post subject: Reply with quote

Centurion

Joined: 21 Jul 2006
Posts: 126

Looks like the GET_DBSIZE_INFO procedure does not come with DB2 8.1 FP 5. I was able to run this procedure and get the info from DB2 8.1 FP12, but not from the other.

It's throing up this error message:
db2 => CALL GET_DBSIZE_INFO(?, ?, ?, 0)
SQL0440N No authorized routine named "GET_DBSIZE_INFO" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884

Any suggestions would be greatly appreciated.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » migration - question reg databases
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.