Hi,
We are facing problem accessing to DB2.
Seems like database manager is down
I tried starting it using db2start but it was neither showing any messages
nor returning to command prompt after finishing start. I do not know
actually if it was trying to start database or hanging somewhere
We rebooted machine and again tried starting db2 but was getting errors
SQL10007N Message "-1393" could not be retrieved. Reason code: "1".
And here is the explanation
$ db2 ? SQL10007N
SQL10007N Message "<msgno>" could not be retrieved. Reason
code: "<code>".
Explanation: The requested message <msgno> could not be
retrieved from the message file. Reason code <code> is one of
the following:
1. The environment variable "DB2INSTANC E" is either not set, or
is set to an invalid instance. Correct it and try again.
2. The message file was found, but the file could not be opened
because of permissions. Check the file permissions of the
files under the message directory.
3. The message file could not be found. Either the file does
not exist, or the directory the message file should be in
does not exist. Check that a either a 'prime' directory (the
default) or a directory with the same name as the 'LANG'
environment variable exists under the message directory.
4. The requested message does not exist in the message file.
Either the message file is outdated, or it is the wrong
one.
5. LC_CTYPE is set to a locale which the database does not
support. Correct it and try again.
6. An unexpected system error occurred. Try execution again.
If problem persists, contact your IBM representative.
7. Not enough memory. An attempt to get private memory failed.
Try again.
User Response: Reissue the command after verifying the
following:
o ensure that the DB2INSTANCE environment variable is set to
the correct literal string for the username attempting this
command
o ensure that correct home directory is specified for the
username attempting this command (i.e. in the /etc/passwd
file)
o ensure that the LANG environment variable is set to the
correct value for the installed language, or is set to 'C'
(defaults to whatever is in the 'prime' directory), on the
username attempting this command
If all of the above are correct and the error still occurs,
reinstall DB2.
And other error at different time was
$ db2start
SQL1072C The database manager resources are in an inconsistent state. DB2
may have been incorrectly terminated, or another application may be using
system resources in a way which conflicts with DB2's use of system
resources. System resource cleanup may be required.
What u suggest ?
We probably can reinstall db2 but there could be following issue
· What will happen to data already residing in db2 if we reinstall
db2? Do u think we have to save that somehow before reinstalling db2?
Is there any ways we can save the data even when database manager is not
running? I have to save the data before reinstalling.
I do not know how database stop responding. I updated AIX on Friday and also
installed IBM HTTP Server, adobe acrobat and C for AIX 6.0. I do not think
those things might have created any problem with DB2.
Warm regards,
Jagdip 3 15625
As to the last part of your question, You can dROP and instance or even
uninstall DB" without damaging or even touching your existing databases.
If you have to go that far in solving your problem, it's fine. Recreate
the instance and/or reinstall the DB2 system. When done and the
instance starts properly with a db2start, do on a command line:
db2 catalog db <yourdbname> on path <path where the db was created>
As to the first part, have you done what the error msg. asks.
Do you have the db2instance set (check with db2set -all)? What were the
results?
HTH' Pierre.
Jagdip Singh wrote: Hi,
We are facing problem accessing to DB2.
Seems like database manager is down
I tried starting it using db2start but it was neither showing any messages nor returning to command prompt after finishing start. I do not know actually if it was trying to start database or hanging somewhere
We rebooted machine and again tried starting db2 but was getting errors SQL10007N Message "-1393" could not be retrieved. Reason code: "1".
And here is the explanation $ db2 ? SQL10007N SQL10007N Message "<msgno>" could not be retrieved. Reason
code: "<code>". Explanation: The requested message <msgno> could not be
retrieved from the message file. Reason code <code> is one of
the following: 1. The environment variable "DB2INSTANC E" is either not set, or
is set to an invalid instance. Correct it and try again. 2. The message file was found, but the file could not be opened
because of permissions. Check the file permissions of the
files under the message directory. 3. The message file could not be found. Either the file does
not exist, or the directory the message file should be in
does not exist. Check that a either a 'prime' directory (the
default) or a directory with the same name as the 'LANG'
environment variable exists under the message directory. 4. The requested message does not exist in the message file.
Either the message file is outdated, or it is the wrong
one. 5. LC_CTYPE is set to a locale which the database does not
support. Correct it and try again. 6. An unexpected system error occurred. Try execution again.
If problem persists, contact your IBM representative. 7. Not enough memory. An attempt to get private memory failed.
Try again. User Response: Reissue the command after verifying the
following: o ensure that the DB2INSTANCE environment variable is set to
the correct literal string for the username attempting this
command o ensure that correct home directory is specified for the
username attempting this command (i.e. in the /etc/passwd
file) o ensure that the LANG environment variable is set to the
correct value for the installed language, or is set to 'C'
(defaults to whatever is in the 'prime' directory), on the
username attempting this command
If all of the above are correct and the error still occurs,
reinstall DB2.
And other error at different time was $ db2start
SQL1072C The database manager resources are in an inconsistent state. DB2 may have been incorrectly terminated, or another application may be using system resources in a way which conflicts with DB2's use of system resources. System resource cleanup may be required.
What u suggest ? We probably can reinstall db2 but there could be following issue
· What will happen to data already residing in db2 if we reinstall db2? Do u think we have to save that somehow before reinstalling db2?
Is there any ways we can save the data even when database manager is not running? I have to save the data before reinstalling.
I do not know how database stop responding. I updated AIX on Friday and also installed IBM HTTP Server, adobe acrobat and C for AIX 6.0. I do not think those things might have created any problem with DB2.
Warm regards,
Jagdip
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Hi Pierre,
Thanks for responding.
I checked db2set -all
$ db2set -all
[g] DB2SYSTEM=mardb 2
[g] DB2ADMINSERVER= db2as
I can see DB2INSTANCE variable by typing
$ echo $DB2INSTANCE
db2inst1
I actually killed all processes owned by db2inst1 after trying above
commands but before i read your e mail.
then i used commands like db2 terminate, db2_kill and ipclean
then i dropped the db2inst1 instance and started database again. Now it
started fine and i also created the instance and tried creating sample
database
$ db2sampl
SQL1005N The database alias "SAMPLE" already exists in either the local
database directory or system database directory.
SQL1013N The database alias name or database name "SAMPLE" could not be
found. SQLSTATE=42705
I do not know what is going on
please advice something
regards,
Jagdip
"Pierre Saint-Jacques" <ps********@vid eotron.ca> wrote in message
news:3F******** ******@videotro n.ca... As to the last part of your question, You can dROP and instance or even uninstall DB" without damaging or even touching your existing databases.
If you have to go that far in solving your problem, it's fine. Recreate the instance and/or reinstall the DB2 system. When done and the instance starts properly with a db2start, do on a command line: db2 catalog db <yourdbname> on path <path where the db was created>
As to the first part, have you done what the error msg. asks. Do you have the db2instance set (check with db2set -all)? What were the results?
HTH' Pierre.
Jagdip Singh wrote: Hi,
We are facing problem accessing to DB2.
Seems like database manager is down
I tried starting it using db2start but it was neither showing any
messages nor returning to command prompt after finishing start. I do not know actually if it was trying to start database or hanging somewhere
We rebooted machine and again tried starting db2 but was getting errors SQL10007N Message "-1393" could not be retrieved. Reason code: "1".
And here is the explanation $ db2 ? SQL10007N SQL10007N Message "<msgno>" could not be retrieved. Reason
code: "<code>". Explanation: The requested message <msgno> could not be
retrieved from the message file. Reason code <code> is one of
the following: 1. The environment variable "DB2INSTANC E" is either not set, or
is set to an invalid instance. Correct it and try again. 2. The message file was found, but the file could not be opened
because of permissions. Check the file permissions of the
files under the message directory. 3. The message file could not be found. Either the file does
not exist, or the directory the message file should be in
does not exist. Check that a either a 'prime' directory (the
default) or a directory with the same name as the 'LANG'
environment variable exists under the message directory. 4. The requested message does not exist in the message file.
Either the message file is outdated, or it is the wrong
one. 5. LC_CTYPE is set to a locale which the database does not
support. Correct it and try again. 6. An unexpected system error occurred. Try execution again.
If problem persists, contact your IBM representative. 7. Not enough memory. An attempt to get private memory failed.
Try again. User Response: Reissue the command after verifying the
following: o ensure that the DB2INSTANCE environment variable is set to
the correct literal string for the username attempting this
command o ensure that correct home directory is specified for the
username attempting this command (i.e. in the /etc/passwd
file) o ensure that the LANG environment variable is set to the
correct value for the installed language, or is set to 'C'
(defaults to whatever is in the 'prime' directory), on the
username attempting this command
If all of the above are correct and the error still occurs,
reinstall DB2.
And other error at different time was $ db2start
SQL1072C The database manager resources are in an inconsistent state.
DB2 may have been incorrectly terminated, or another application may be
using system resources in a way which conflicts with DB2's use of system resources. System resource cleanup may be required.
What u suggest ? We probably can reinstall db2 but there could be following issue
· What will happen to data already residing in db2 if we
reinstall db2? Do u think we have to save that somehow before reinstalling db2?
Is there any ways we can save the data even when database manager is not running? I have to save the data before reinstalling.
I do not know how database stop responding. I updated AIX on Friday and
also installed IBM HTTP Server, adobe acrobat and C for AIX 6.0. I do not
think those things might have created any problem with DB2.
Warm regards,
Jagdip
-- Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com Reconstruct address: Remove the two junk and replace at and dot by their symbols. IBM DB2 Cerified Solutions Expert - Administration SES Consultants Inc.
Hi,
I followed your steps but i think this idea did not worked.
I dropped instance and created another instance
then i started db2 and tried cataloging my old database
and then i tried connecting to that database which gave me error saying "
The database alias name or database name "sample" could not be found.
It seems like this will create an entry in the SYSTEM catalog directory no
matter if database actually exists on the disk or not.
Do u think catalog command actually check if database exists physically on
the disk or it blindly make entry in the system table.
regards,
Jagdip
"Pierre Saint-Jacques" <ps********@vid eotron.ca> wrote in message
news:3F******** ******@videotro n.ca... As to the last part of your question, You can dROP and instance or even uninstall DB" without damaging or even touching your existing databases.
If you have to go that far in solving your problem, it's fine. Recreate the instance and/or reinstall the DB2 system. When done and the instance starts properly with a db2start, do on a command line: db2 catalog db <yourdbname> on path <path where the db was created>
As to the first part, have you done what the error msg. asks. Do you have the db2instance set (check with db2set -all)? What were the results?
HTH' Pierre.
Jagdip Singh wrote: Hi,
We are facing problem accessing to DB2.
Seems like database manager is down
I tried starting it using db2start but it was neither showing any
messages nor returning to command prompt after finishing start. I do not know actually if it was trying to start database or hanging somewhere
We rebooted machine and again tried starting db2 but was getting errors SQL10007N Message "-1393" could not be retrieved. Reason code: "1".
And here is the explanation $ db2 ? SQL10007N SQL10007N Message "<msgno>" could not be retrieved. Reason
code: "<code>". Explanation: The requested message <msgno> could not be
retrieved from the message file. Reason code <code> is one of
the following: 1. The environment variable "DB2INSTANC E" is either not set, or
is set to an invalid instance. Correct it and try again. 2. The message file was found, but the file could not be opened
because of permissions. Check the file permissions of the
files under the message directory. 3. The message file could not be found. Either the file does
not exist, or the directory the message file should be in
does not exist. Check that a either a 'prime' directory (the
default) or a directory with the same name as the 'LANG'
environment variable exists under the message directory. 4. The requested message does not exist in the message file.
Either the message file is outdated, or it is the wrong
one. 5. LC_CTYPE is set to a locale which the database does not
support. Correct it and try again. 6. An unexpected system error occurred. Try execution again.
If problem persists, contact your IBM representative. 7. Not enough memory. An attempt to get private memory failed.
Try again. User Response: Reissue the command after verifying the
following: o ensure that the DB2INSTANCE environment variable is set to
the correct literal string for the username attempting this
command o ensure that correct home directory is specified for the
username attempting this command (i.e. in the /etc/passwd
file) o ensure that the LANG environment variable is set to the
correct value for the installed language, or is set to 'C'
(defaults to whatever is in the 'prime' directory), on the
username attempting this command
If all of the above are correct and the error still occurs,
reinstall DB2.
And other error at different time was $ db2start
SQL1072C The database manager resources are in an inconsistent state.
DB2 may have been incorrectly terminated, or another application may be
using system resources in a way which conflicts with DB2's use of system resources. System resource cleanup may be required.
What u suggest ? We probably can reinstall db2 but there could be following issue
· What will happen to data already residing in db2 if we
reinstall db2? Do u think we have to save that somehow before reinstalling db2?
Is there any ways we can save the data even when database manager is not running? I have to save the data before reinstalling.
I do not know how database stop responding. I updated AIX on Friday and
also installed IBM HTTP Server, adobe acrobat and C for AIX 6.0. I do not
think those things might have created any problem with DB2.
Warm regards,
Jagdip
-- Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com Reconstruct address: Remove the two junk and replace at and dot by their symbols. IBM DB2 Cerified Solutions Expert - Administration SES Consultants Inc. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Kostatus |
last post by:
I have a virtual function in a base class, which is then overwritten by a
function of the same name in a publically derived class. When I call the
function using a pointer to the derived class (ClassB* b; b->func(); ) the
base-class function is called instead of the new function in the derived
class. All other similar functions (virtual in the base class and
overwritten in the the derived class) work fine, it's just this one
function. ...
|
by: Peter Olcott |
last post by:
www.halting-problem.com
|
by: Ian Stanley |
last post by:
Hi,
Continuing my strcat segmentation fault posting-
I have a problem which occurs when appending two sting literals using
strcat.
I have tried to fix it by writing my own function that does the strcat
(mystract). Program below.
However this appears not to have fixed the problem and I don't know why it
shouldn't ?
Any further help as to what else I am doing wrong will be appreciated
regards
|
by: Jon Davis |
last post by:
If I have a class with a virtual method, and a child class that overrides
the virtual method, and then I create an instance of the child class AS A
base class...
BaseClass bc = new ChildClass();
.... and then call the virtual method, why is it that the base class's method
is called instead of the overridden method? How do I fix this if I don't
know at runtime what the child class is? I'm using
Activator.CreateInstance() to load the...
|
by: Ammar |
last post by:
Dear All,
I'm facing a small problem.
I have a portal web site, that contains articles, for each article, the end
user can send a comment about the article.
The problem is:
I the comment length is more that 1249 bytes, then the progress bar of the
browser will move too slow and then displaying that the page not found!!!!
If the message is less than or equal to 1249 then no problem.
| |
by: Dany |
last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by Microsoft must be installed on their servers.
Now german Umlaute (ä, ü, ö) and quotes are returned incorrectly in SOAP fault responses.
This can be easily verified:
Implement the following in a web service method (just raises a SOAPException with a...
|
by: Mike Collins |
last post by:
I cannot get the correct drop down list value from a drop down I have on my
web form. I get the initial value that was loaded in the list.
It was asked by someone else what the autopostback was set to...it is set to
false.
Can someone show me what I am doing wrong and tell me the correct way? Thank
you.
In the page load event, I am doing the following:
|
by: =?Utf-8?B?am8uZWw=?= |
last post by:
Hello All,
I am developing an Input Methop (IM) for PocketPC / Windows Mobile (PPC/WM).
On some
devices the IM will not start. The IM appears in the IM-List but when it is
selected from the list athe result is that the standard (QWERTY) keyboard
appears.
I found that many ( all?) ISV's who make IM's have customers reporting this
problem. My research on the internet brought me to the conclusion it is some
|
by: sherifbk |
last post by:
Problem description
==============
- I have 4 clients and 1 server (SQL server)
- 3 clients are Monitoring console 1 client is operation console
- Monitoring console collects some data from the control unit and
store them into the Sql server
- The operation console then retrieve this data from the sql for
reporting and statistics purposes
- I am using ODBC connection
- The problem is that the operation console is not able to...
|
by: AceKnocks |
last post by:
I am working on a framework design problem in which I have to design a C++ based framework capable of solving three puzzles for now but actually it should work with a general puzzle of any kind and I need your able help in this activity.
Objective -
In this activity you will design a framework capable of solving any puzzle of a specific type and, as a test of this framework, use the framework to solve a very simple puzzle. In this first...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |