473,322 Members | 1,494 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,322 software developers and data experts.

Message SQL22212N when trying to run a task

oba
Environtment: DB2 UDB ESE v8.1, fixpack 6a on Windows2003 Server Enterprise
Edition. We bought a new server and have been using as a test environment
for the system until last weekend. Then we changed: the old production
environment became test, and the test environment became production. I
that prosess the servers changed name and ip address. The old former
production server changed name from SMSS01 (139.108.97.190) to SMSS03
(139.108.97.180) and became our test environment, and the former test
server changed from SMSS03 (139.108.97.180) to SMSS01 (139.108.97.190) and
became our production environment.

We wanted to do it this way because we wanted the new and more powerful
server to be production. And we used it as test server in testing db2
version 8.1 before migrating from 7.2. So now we have test at 7.2 (the old
server9 and production at 8.1 (the new server).

I hope you are with me so far :-)

But now I have a problem running scripts from Task Center. We I try to
start them I get the following error message: SQL22212N A DB2
Administration Server communication error has been detected. Client
system: "139.108.97.190". Server system "139.108.97.180". For some reason
db2 seems to remember the old ip address ( and perhaps the name aslo).

Does anyone know what I can do to resolve this situation ?

BTW: When I run the script code from a CLP window there is no problem.
Nov 12 '05 #1
1 7405
"oba" <od**********@ergo.no> wrote in message news:<01******************************@localhost.t alkaboutdatabases.com>...
Environtment: DB2 UDB ESE v8.1, fixpack 6a on Windows2003 Server Enterprise
Edition. We bought a new server and have been using as a test environment
for the system until last weekend. Then we changed: the old production
environment became test, and the test environment became production. I
that prosess the servers changed name and ip address. The old former
production server changed name from SMSS01 (139.108.97.190) to SMSS03
(139.108.97.180) and became our test environment, and the former test
server changed from SMSS03 (139.108.97.180) to SMSS01 (139.108.97.190) and
became our production environment.

We wanted to do it this way because we wanted the new and more powerful
server to be production. And we used it as test server in testing db2
version 8.1 before migrating from 7.2. So now we have test at 7.2 (the old
server9 and production at 8.1 (the new server).

I hope you are with me so far :-)

But now I have a problem running scripts from Task Center. We I try to
start them I get the following error message: SQL22212N A DB2
Administration Server communication error has been detected. Client
system: "139.108.97.190". Server system "139.108.97.180". For some reason
db2 seems to remember the old ip address ( and perhaps the name aslo).

Does anyone know what I can do to resolve this situation ?

BTW: When I run the script code from a CLP window there is no problem.


Your DAS may has problem.
Try to restart your DAS by db2admin stop/start.
Nov 12 '05 #2

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

Similar topics

0
by: Geraint Evans | last post by:
Hi All, I am trying to access a Transform Data Task in a DTS by double clicking it. When I do, I get a message similar to "HResult of 0x80004005 (-2147467259) returned Unexpected error...
8
by: Pola | last post by:
Please Help I am using VC++ in win 2000 In my appl (Win32 project) I want to control the close operation of the apl (for example if somebody will try to close appl from the "Windows Task Manager")...
0
by: David Elliott | last post by:
I am trying to group data. I have a daily record that contains multiple projects and multiple items in the project. I would like to roll the daily data into project 1 and all the items that go...
3
by: Pradeep Kumar C | last post by:
Hi , I am working on a ASP.Net Web Application which need some requirement as given below. Let's say two user's A and B. When a User A Assign a task to B , Then B need to get some sort of...
10
by: WT | last post by:
Hello, I have been publishing my web site many times to the remote where resides my final web site. Everything was ok, but to-day, without any configuration change, vs doesn't copy final files...
8
by: Dave | last post by:
I am trying to write an event-driven application with no main window that runs "forever". It waits on a named event and then displays a window depending on data pased in a memory-mapped file. I...
3
by: e name | last post by:
Hello, I am getting "Action Cancelled" message on an asp page which is running a process that takes more then 25 minutes. I have "Friendly error message" turned off on browser setting. And what...
0
by: Andreas Tawn | last post by:
Does anyone know how to properly kick off a script using Windows Import os and add os.system("pause") at the end of AutomatedTestRun.py to keep cmd open. As far as not seeing any output, I...
1
by: oct08 | last post by:
Hi all, I'm trying to trouble shoot an issue where I am running an Access/VBA app, which grabs some data and puts it into a few text files. It usually takes 10 minutes to run (though after even a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.