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 "DB2INSTANCE" 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 15560
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 "DB2INSTANCE" 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=mardb2
[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********@videotron.ca> wrote in message
news:3F**************@videotron.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 "DB2INSTANCE" 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********@videotron.ca> wrote in message
news:3F**************@videotron.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 "DB2INSTANCE" 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...
|
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...
|
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();...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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,...
|
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...
|
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...
|
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,...
| |