473,573 Members | 5,052 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Control center doesn't start

Hi all,

I'm running DB2 8.1.5 on Windows 2000 professional SP4.

When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.

It happens with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).

Where can I find a log in order to understand the problem?

Thanks a lot.

Bye

Franco
Nov 12 '05 #1
6 10708
DB2 has several logs and I'm not sure which ones contain information about
Control Center problems. Also, I haven't upgraded to V8 yet. However, if you
use your file system search to look for all files under \SQLLIB that have a
file extension of .log, you should find all the logs. Then, its just a
matter of looking through the last part of each of them until you find
something about the Control Center.

Rhino

"Franco Lombardo" <f_********@hot mail.com> wrote in message
news:2g******** ****@uni-berlin.de...
Hi all,

I'm running DB2 8.1.5 on Windows 2000 professional SP4.

When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.

It happens with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).

Where can I find a log in order to understand the problem?

Thanks a lot.

Bye

Franco

Nov 12 '05 #2
> However, if you
use your file system search to look for all files under \SQLLIB that have a file extension of .log, you should find all the logs.


The *.log files that are in my SQLLIB dir are not updated after staring
Control Center :-(

Other hints?

Thanks a lot.

Bye

Franco

Nov 12 '05 #3

"Franco Lombardo" <f_********@hot mail.com> wrote in message
news:2g******** ****@uni-berlin.de...
However, if you
use your file system search to look for all files under \SQLLIB that
have a
file extension of .log, you should find all the logs.


The *.log files that are in my SQLLIB dir are not updated after staring
Control Center :-(

Other hints?

Has this installation of DB2 ever worked for you? I'm not clear if it was
working and then stopped or has never worked.

If it has never worked, I would suspect an installation error. If it used to
work but has suddenly stopped working, it would seem likely that your
environment changed in some way to cause the failure; maybe you could look
at that.

The other thing you could try would be to see what the current logging level
is and increase it if it is too low. Do this at a DB2 CLP prompt:

db2 get dbm cfg | more

Near the bottom of the first page of output, you should see a line that
starts:

Diagnostic error capture level (DIAGLEVEL) = ?

If the value there is less than 4, you aren't at the maximum value. In that
case, you could increase the level of logging to 4 via this command:

db2 update dbm cfg using diaglevel 4

Then issue 'db2stop' and 'db2start' and try starting the Control Center
again. After the Control Center fails again, you should find significantly
more information in the DB2 logs than you had before. Maybe something there
will give you a clue.

If none of that works, try calling IBM Support if that is an option for you.

Rhino
Nov 12 '05 #4
Rhino,
thank you a lot for your answer.
The control center was working and then stopped, but I really don't know
when,
as I seldom use it, since I prefer command line tools.
The DB2 engine instead works fine.
The diaglevel was 3. After issuing the commands you suggested, now I find
this lines in db2diag.log:
_______________ ___________

2004-05-19-09.39.25.928000 Instance:DB2 Node:000
PID:1684(db2jav it.exe) TID:1532 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0010D0A0 : 0x00000002 ....

PID:1684 TID:1532 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\db 2nodes.cfg

2004-05-19-09.39.25.938001 Instance:DB2 Node:000
PID:1684(db2jav it.exe) TID:1532 Appid:none
oper system services sqlofindn Probe:100

GetLastError:
0x00105B9C : 0x00000012 ....

2004-05-19-09.39.26.649000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EA70 : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\db 2nodes.cfg

2004-05-19-09.39.28.822000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2conee.lvl

2004-05-19-09.39.28.832000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2conpe.lvl

2004-05-19-09.39.28.842001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2ese.lvl

2004-05-19-09.39.28.862000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E494 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWDIR

2004-05-19-09.39.28.882000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E470 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWBAK

2004-05-19-09.39.28.892001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E99C : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWDIR

2004-05-19-09.39.28.912001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E978 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWBAK

2004-05-19-09.39.28.932000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqlofica Probe:10

PID:528 TID:1608 Node:000 Title: SQLCA ˆ
0x0006F4D8 : 5351 4C43 4120 2020 8800 0000 E1FA FFFF SQLCA ........
0x0006F4E8 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0006F4F8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F508 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F518 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F528 : 2020 2020 2020 2020 5351 4C30 3830 3135 SQL08015
0x0006F538 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x0006F548 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0006F558 : 2020 2020 2020 2020

2004-05-19-09.39.28.992000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
Client Config cfgbAPPC::getAP PCValues Probe:4

PIF (APPC) initialize failed: rc =
0x0006EB20 : 0x00000001 ....
_______________ _______________ ___

Any hints?

Thanks again.

Bye

Franco
Nov 12 '05 #5
There is an SQL08015 in the third last block of the log excerpt in your
note. According to the Message Reference:
----------------------------------------------------------------------------
--------------------------------------
SQL8015N The version of the DB2 Connect product you are using is not
licensed for updating multiple databases in the same transaction.

Explanation: This version of DB2 Connect is limited to working with a single
database in a transaction. It does not support 2-phase commit protocol.

User Response: Upgrade to a full function DB2 Connect product such as DB2
Connect Personal Edition or DB2 Connect Enterprise Edition to be able to
update multiple databases in a single transaction.

sqlcode: -8015

sqlstate: 42968

----------------------------------------------------------------------------
-----------------------------------

This seems like an odd error to get while you are just trying to start the
Control Center and haven't actually selected a database yet. This message
would be more reasonable if you were running a program that tried to access
multiple databases.

The last block of the log excerpt says that APPC initialization failed. I
don't much about APPC beyond the fact that it is a communication protocol
but this may explain why your Control Center isn't doing anything; I think
APPC needs to be working before the Control Center can work correctly. It
also seems quite possible that the SQL08015 is causing the APPC
initialization problem but I can't be sure since I don't know how DB2
Connect interacts with APPC.

My guess is that something in your environment which affects APPC changed
since the last time you used the Control Center. Fixing the APPC
configuration may get the Control Center working again.

Use the Search box in the DB2 Information application to look up APPC and
find out the details about configuring APPC. On my Windows XP machine
running DB2 V7.2, that application is at Start/All Programs/IBM
DB2/Information/DB2 Information. The search box is in the "Search the DB2
Online Information" area near the top of the page that appears when you
click that icon.

If fixing the APPC initialization doesn't help, maybe someone else with more
knowledge of APPC (and DB2 Connect) can suggest something. If not, try IBM
Support.

Good luck!

Rhino

"Franco Lombardo" <f_********@hot mail.com> wrote in message
news:2h******** ****@uni-berlin.de...
Rhino,
thank you a lot for your answer.
The control center was working and then stopped, but I really don't know
when,
as I seldom use it, since I prefer command line tools.
The DB2 engine instead works fine.
The diaglevel was 3. After issuing the commands you suggested, now I find
this lines in db2diag.log:
_______________ ___________

2004-05-19-09.39.25.928000 Instance:DB2 Node:000
PID:1684(db2jav it.exe) TID:1532 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0010D0A0 : 0x00000002 ....

PID:1684 TID:1532 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\db 2nodes.cfg

2004-05-19-09.39.25.938001 Instance:DB2 Node:000
PID:1684(db2jav it.exe) TID:1532 Appid:none
oper system services sqlofindn Probe:100

GetLastError:
0x00105B9C : 0x00000012 ....

2004-05-19-09.39.26.649000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EA70 : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\db 2nodes.cfg

2004-05-19-09.39.28.822000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2conee.lvl

2004-05-19-09.39.28.832000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2conpe.lvl

2004-05-19-09.39.28.842001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006EF9C : 0x00000002 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\cfg\db 2ese.lvl

2004-05-19-09.39.28.862000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E494 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWDIR

2004-05-19-09.39.28.882000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E470 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWBAK

2004-05-19-09.39.28.892001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E99C : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWDIR

2004-05-19-09.39.28.912001 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0006E978 : 0x00000003 ....

PID:528 TID:1608 Node:000 Title: Path/Filename
C:\Programmi\IB M\SQLLIB\DB2\SQ LGWDIR\SQLGWBAK

2004-05-19-09.39.28.932000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
oper system services sqlofica Probe:10

PID:528 TID:1608 Node:000 Title: SQLCA ˆ
0x0006F4D8 : 5351 4C43 4120 2020 8800 0000 E1FA FFFF SQLCA ........
0x0006F4E8 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0006F4F8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F508 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F518 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0006F528 : 2020 2020 2020 2020 5351 4C30 3830 3135 SQL08015
0x0006F538 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x0006F548 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0006F558 : 2020 2020 2020 2020

2004-05-19-09.39.28.992000 Instance:DB2 Node:000
PID:528(javaw.e xe) TID:1608 Appid:none
Client Config cfgbAPPC::getAP PCValues Probe:4

PIF (APPC) initialize failed: rc =
0x0006EB20 : 0x00000001 ....
_______________ _______________ ___

Any hints?

Thanks again.

Bye

Franco

Nov 12 '05 #6
You can create a trace with the following syntax: db2cc -tf cc.out (I
believe db2tc -tf tc.out should also work). You
might see an error in there which you can interpret but you might also need
to call service.

"Franco Lombardo" <f_********@hot mail.com> wrote in message
news:2g******** ****@uni-berlin.de...
Hi all,

I'm running DB2 8.1.5 on Windows 2000 professional SP4.

When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.

It happens with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).

Where can I find a log in order to understand the problem?

Thanks a lot.

Bye

Franco

Nov 12 '05 #7

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

Similar topics

0
449
by: Sonu K Mehrotra | last post by:
mysql server is <172.16.27.39> running on Linux 9.1 I have installed mysql control center (client GUI) on 172.16.27.252 running on Windows 2000 advanced server The machines are connected in LAN When I open the start>programs>mysql control center>mysql control center to register the server
0
1328
by: Ingo Kollesch | last post by:
Moin, i will work, remote acces on the server. After the login, I open the control center an when I click on "Database". The System message is "der Befehl DB2Start is noch nicht abgesetzt". When I will start the Database System message is "Database ist aktiv". My problem is i can not see the tables the control center and when I start the...
2
4270
by: serge | last post by:
Where can I find this when I install v8.2? Thank you
1
1550
by: Jurgen Haan | last post by:
Hi. We just experienced an odd phenomenon in Control Center. One of my colleagues just performed a browse on a table and accidentally changed a value in the resultset. He didn't press OK or anything, he didn't even press enter to commit the change in the grid, he just altered a value in a cell of the result grid. But doing so, he made...
0
1064
by: Artur | last post by:
Hi, Let's say I choose two languages during DB2 installation (English and Polish) on Windows. When I start DB2 Control Center it displays all messages in Polish (as it is a default language on my Windows). How can I start Control Center in English (without modifying regional setting on Windows)?
8
5883
by: bienwell | last post by:
Hi, I have a problem of displaying data bound by a datalist control. In my table, I have a field Start_date which has Short Date data type. I tried to update this field by Current Date. After that, I display End_Date on the DataList control. The output looks like 3/18/2005 12:00:00 AM . I'd like to format data for this field to be...
11
30089
by: Hoku | last post by:
I am using dual monitors on a dual head ATI AGP4x video card. I installed the Nov 11 2005 release of ATI's catalyst control center with Hydravision to manage the dual monitor setup. I recently updated to .NET v2 and run Zone Alarm Internet Sec Suite 2006 for firewall and av. When I log off/shut down the computer a dialog box appears as...
1
2163
by: Matt | last post by:
I have taken a backup of a production database and copied it to a test server. I'm attempting to use the Control Center to create the database from the backup. However, when I get to the screen to select the backup to restore from, there are no backup files visible through the Control Center even if I navigate to where I copied the backup...
3
7959
by: Frank Swarbrick | last post by:
We are just starting to use DB2. I have a question about Control Center and port 523. Our DBA set up a database that listens on port 30280 (I have no idea where that port number came from...). Our security guy opened that port so I can access it from my workstation. It seems to work, but Control Center seems to also want to connect to port...
0
7707
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...
1
7800
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...
0
8086
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
6432
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...
1
5605
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3743
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2227
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
1
1325
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1048
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.