How can I take database offline(command window) before performing
backup and restoring operations?
Thanks

Which of the UDB 8.2.2 ESE unix executables really need to
gain root privilege while they are running?
In my installation, the db2sysc file is owned by the instance-owner
(and relevant admin group ownership), but when the db2-instance starts

We are running with DB2 V7 Fp12.
When stopping the apply when apply isn't active the asnastop command
displays the informational message
ASN0889I No Apply program running with the qualifier '<apply-qual>'

I don't want recreate all instances/settings and catalog...
8.2 win32
Andy

In the command windows, I can enter commands like "db2 get dbm cfg" and
"db2 get db cfg for sample" to see the configuration parametes in
details
By using what command I can alter a particular parameters value?

For the Configuration Assistant,
why gave me such errors when I try to add remote database "sample" on
linux (DB2 ESE UDB  version 8)using "add database wizard" to my local
DB server

I have to repost my question for help.
Yesterday I set up two DB UDB ESE V8.2 server on linux and windows
platform, respectively. Both servers have been connected without any
problems

To retrieve data from a query where multiple rows can be returned, a
cursor can be used.
Different programming interface exist for cursors: embedded SQL, CLI,
SQL PL, SQLJ, JDBC.

How can I know TCP/IP port number for SVCENAME db2c_DB2 (DB2 ESE UDB
8.0 under windows)?
thanks

DB2 user OS to do the authenticate.
For security reason, the password of the used used by the application
need to be changed.
To change the source is easy, but there is hundreds of applications

When I start db2cc, the program hangs with memory access violation in
javaw.exe. Strating with trace option, in java trace file I found the
following information:
0SECTION       TITLE subcomponent dump routine

I am using dynamic SQL in my Procedure that has one parameter named
Dep_ID varchar(50).
Inside procedure, I need one dynamic SQL to fulfill the same function
like:

Anyone know how to get a copy and 2-node license of Tivoli System
Automation that comes free with DB2 8.2 ESE for Linux? This is used to
control failover for HADR.

I created a procedure with dynamic SQL. Building is successful.But when
I run it, it shows me the following error:
A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL0104N
An unexpected token "pd.proposal_id  , pd.item_id , psd.year_id" was

I have some tables on DB2 Z/OS 7.1 with SMALLINT, DECIMAL, TIMESTAMP,
DATE and CHAR datatypes.
I already have unload utilities crafted so I would just like to unload
some data on Z/OS for about 10 tables and then load them on the Windows