Another thing why the offline backup is giving you this error "SQL1035N The database is currently in use. SQLSTATE=57019" is because the database was active.
I'll recommend thess steps:
1) Db2 "force application all"
2) db2 deactivate db <db_name>
3) db2 list application...
Yes, after all connections to database are gone. You can simply connect to it again (db2 connect to <db_name>) or activate the database (db2 activate db <db_name>)
Thank you
Hello;
On my Dev Machine, everytime I try to start DB2 by issuing db2start I get this error:
SQL5043N Support for one or more communications protocols failed to start successfully. However,
core database manager functionality started successfully.
When I looked the msg. sql5043n, it says that...
Hello;
On my Dev Machine, everytime I try to start DB2 by issuing db2start I get this error:
SQL5043N Support for one or more communications protocols failed to start successfully. However,
core database manager functionality started successfully.
When I looked the msg. sql5043n, it says that...
Hi Marc;
Well that's a good question! I don't think I have a compiler in my machine. AS you can imagine, I'm UNIX person I never worked DB2 on Windows. So how do you look for the compiler. and if I don't have, is there a site that I can download.
So, basically I need to go where the compiler...
Hi;
I'm trying to activate USER EXIT and LOG REATIAN. I follow up all the steps needed to do that. Which is under c:\Program Files\SQLLIB\SAMPLE, I opened the db2uext2.c and then I did
1. Copy "db2uext2.cdisk" to "db2uext2.c" and place this file
into a working directory...
Hi Bi;
You see I was using for DB2 I don't if you ever worked on db2 but to start db2 you have to be in this directory c:/program files/sql/bin and you execute a file called db2cmd.exe. once you run that it will open another window and in there you can perform db2 tasks.
my question is how can...
Hi;
I was wondering if there's any one who ever used DB2 win2000 and use UWIN/CYGWIN.
I'm trying to run all my scripts I have for db2 on AIX/UNIX over win2000. I know UWIN/CYGWIN has the capability to run UNIX/AIX commands over Window2000.
But my concern is, to initialized Command line...
Hi
Thanks for this respond (UWIN). The reason I was looking for this is that I have DB2 installed in my Win 2000 Machine (new project).
I also support DB2 on AIX which I have lots of scripts in that machine. Now I was trying to use those scripts in my new project (win2000).
So, when I...
Hi;
I have just assigned to a new project that uses Windows2000. I have a lots of script that I use a Databases that runs on AIX machine.
What I'm looking for if there's any one who knows any utilities that can convert AIX scripts into Windows2000. Or/and if some one who manages DB2 on...
Hello;
I have just took a new project for DB2 on Windows2000. I also have several DB2 projects on AIX machine.
My question is this: We do have several Scripts that maintenance our databases on AIX machine. i.e. backups, reorgs, runstats etc.
Now, I'm trying to convert these scripts in...
Did you manually copied the database... i.e. copy C:\db2\NODE0000\SQL00001 using op.sys commands and then moved that file across.
If that's the case... then is wrong. You see DB2 doesn't work like that.... you can access a database from 1 machine to the other machines by
1) move the database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.