473,223 Members | 1,845 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,223 software developers and data experts.

problem with db2

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


Nov 12 '05 #1
3 15518
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.

Nov 12 '05 #2
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.

Nov 12 '05 #3
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.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
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...
117
by: Peter Olcott | last post by:
www.halting-problem.com
18
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...
28
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();...
6
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...
16
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...
2
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...
0
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...
1
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...
9
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...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.