473,566 Members | 2,784 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2ADVIS Error: SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INF O")

1 New Member
Have 2 databases under the same db2 udb instance (aix 5.3.0.0, db2 udb V8.1, fixpak 9).

Able to run the db2advis command successfully against one database. On the other database, always receive the following error. Any ideas/info would be greatly appreciated. Thanks!

Using user id as default schema name. Use -n option to specify schema
CALL SYSPROC.GET_DBS IZE_INFO failed (workaround - use -l)

SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INF O") is implemented
with code in library or path "...sqllib/function/db2stmg", function
"get_dbsize_inf o" which cannot be accessed. Reason
*************** *************** *******
* CONTENTS OF SQLCA *
*************** *************** *******

SQLCABC = 136
SQLCODE = -444
SQLERRMC = *IZE_INFO▒GET_D BSIZE_INFO▒...s qllib/function/db2stmg▒get_dbs ize_info▒4
SQLERRP = SQLERLIB
sqlerrd[0] = 0
sqlerrd[1] = 0
sqlerrd[2] = 0
sqlerrd[3] = 0
sqlerrd[4] = 0
sqlerrd[5] = 0
SQLWARN =
SQLSTATE = 42724
Critical SQLCODE. Exiting db2advis ...
The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-444]
Oct 19 '06 #1
0 2236

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2491
by: yogesh | last post by:
Greetings, I have written a C language Stored Procedure on DB2 UDB V8 on solaris. While execting the SP i am gettign the following the error : db2 => call truncate ('BUSINESS','ACCT')@ SQL0444N Routine "TRUNCATE" (specific name "TRUNCATE_TABLE") is implemented with code in library or path ".../sqllib/function/functions", function
12
2852
by: Jean-Marc Blaise | last post by:
Hi Folks, I'm getting this message with the XML tutorial: getstart_exportXML.cmd file: SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is implemented with code in library or path "\db2xmlfn", function "dxxContent_varchar2file" which cannot be accessed. Reason code: "4". SQLSTATE=42724 DB20000I The TERMINATE command...
2
9213
by: Matthew Louden | last post by:
using System.Data; using System.Data.SqlClient; //etc... SqlConnection conn = new SqlConnection(connString); SQLDataSetCommand myCmd = new SQLDataSetCommand("select * from Test;", conn); DataSet ds = new DataSet(); myCmd.FillDataSet(ds, "test");
3
4924
by: NG | last post by:
I installed DB2 in Linux OS. I tried to create database and I am getting the following error message: SQL0444N Routine "db2spcat" (specific name "SQL060216094049640") is implemented with code in library or path ".../sqllib/function/db2spcat", function "db2spcat" which cannot be accessed. Reason code: "4". SQLSTATE=42724 I looked at...
0
1439
by: Alok | last post by:
Hi Guys, The latest issue of MSDN mag has an article by Scott Swigart about writing COM wrappers for use by VB6/VBA etc. However, when I try to use the dll from VBA I get the error -2147024894 "File or assembly name FX20Wrapper, or one of its dependencies, was not found." Can anyone help me to understand the error. Thanks.
3
3680
by: siva | last post by:
Hi All. We recently migrated our production database to V8 Fixpack 12.. Since then db2advis stopped working with following error.. SQL0805N Package "NULLID.DB2ADVMI 0X7541505252644557" was not found. SQLSTATE=51002.. We did bind all the pacakges.. Are we missing something. Thanks Thanks ss
6
2012
by: darren28 | last post by:
Hi, I have a pretty basic question that I can't seem to figure out. I'm trying to open a form with a specific name that changes depending on the value of a cell. For instance (simplified)... sub openForm() dim formNumber as integer formNumber = cells(1,1)
1
1023
by: manjunathatv | last post by:
I am trying to select a set of nodes in an xml document. (like xmlDocument.SelectNodes(xPath)) but the nodes are at different levels. so am not getting all the node with that node name in all the levels. how to select nodes with a specific name which are at different level? thanx in advance.
0
2182
by: suniltcs | last post by:
When I run DB2advis , i get below error message. ). db2advis -d aqwrwist -l -1 -s "select * from wis.cond with ur;" Using user id as default schema name. Use -n option to specify schema SQL0818N A timestamp conflict occurred. SQLSTATE=51003
0
7666
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7584
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8108
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7951
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6260
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5213
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3643
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
925
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.