Search Result

How do you recover from a

BACKUP PENDING. SQLSTATE=57019 on DB2 (XP O/S)?

Reason probably because I set LOGARCHMETH1 to TSM in error
Need to be LOGARCHMETH1 OFF

Current situation means I cannot connect to database because it has 'BACKUP PENDING' - so I cannot do anything with the database - need a 'get out of jail' solution.

Help please.

Hi, I am starting with IBM DB2 for spatial data and have installed DB2 express for mac but am unable to install DB2 spatial extension as I couldn't find any relevant links for spatial extension for mac. Please help me as am unable to proceed in my work.


Thanks!

I am looking for a PowerShell routine that will prune logfiles based on the date of my oldest backup. I keep a week of daily backups and wish to run this routine weekly. Also, as I am brand new to Powershell, how can you schedule it to run from the Windows Scheduler?

In DB2 UDB, I call a stored procedure, which in turn calls a number of other stored procedures. I am used Command Editor.

Here is the call which fails and the error message:
call arc.arc_restore ;
------------------------------------------------------------------------------
call arc.arc_restore
SQL0104N An unexpected token "CALL ARC.ARC_DISABLE _TRIG('MAXIMO', 'WORKLOG_T"
was found following...

How do you set grant privileges to the particular database??? I have two databases on the same port number so in order to access two databases i want to set grant privileges .After setting them is it possible to execute a query between the two databases.Is it possible to execute a query between the two databases without using replication and federation...

for example i have two databases and they are in the same port number and a query...

Hi All,

I am not able to connect to DB2 database from java, no matter what driver I use.

I either get
"No suitable driver found" for Class.forName(" com.ibm.db2.jcc .DB2Driver");

OR

For Class.forName(" COM.ibm.db2.jdb c.app.DB2Driver ");

"Exception in thread "main" com.ibm.db2.jcc .am.yn: [jcc][t4][2030][11211][3.57.82] A communication...

Hi ,

I have got a pipe delimited file which I am loading into the DB using the DB2 Load utility.
Now some of the rows in the pipe delimited file don't have the data for the respective columns , and therefore they get rejected by the Load utility.

I am aware of the Null indicator , but that is available only for ASCII files
Can anybody please guide me the Null Indicator equivalent to be used incase of delimited...

Hi,
I have Db2 8.1.1.152 FixPack 17 on AIX using SAP with DB2. we wanted to have a DR site. we are backing our production using TSM. we just restored the filesystem and later the DB2 data on DR site. every thing seemed to work fine. now we want to have online DR, for this we are shipping archive logs from production to DR site. but if we say
db2 rollforward db <dbname> to end of logs and complete
then this DR DB2 starts...

Hi,

Does anyone know a way to get a list of nodes from list of instances? Meaning, I can have a list of instances from customers (or can get a list of instances from db2ilist). However, I want to know to which "NODE" these instances belong to? LIST ADMIN NODE DIRECTORY not providing details of instances the node has.

Thanks in advance.
Shailesh

With DB2 z os v8, is it possible to load a table using an input file for all columns but one and actually specify a value for that one column in the load cards with the sysin?


like
LOAD DATA INTO TABLE ABC
(COLA POSITION(1) INTEGER,
COLB POSITION(5) CHAR(1),
COLC CHAR(3) 'DEF')

Where columns a and b get values from input file but all occurances...

This question was last asked in this forum in 2005
http://bytes.com/topic/db2/answers/184494-deferring-constraints-db2

I have a similar requirement, where the referential integrity checking has to be deferred until COMMIT is issued.

Something similar to DEFERRABLE
INITIALLY DEFERRED or SET CONSTRAINTS ALL DEFERRED in Oracle.

Is there an option available in DB2 to achieve this?
...

Hi. I have installed DB2 8.1.7 to a Windows 7 system and it is not working like you cannot add databases wtih the error "SQL10007N Message "-1332" could not be retrieved. Reason code: "5"." I wonder if there is a compatibility pack or something needed for it to work correctly. Even the COntrol Center doesn't work with the error "CLI0647E Error allocating DB2 environment handle, rc=-1.
?"

Hello,

I'd like to have early feedback of a new architecture that I'm thinking for our customers that has db2 dbms.

I have many copies of the same db schema around the globe; suppose that each belongs to a particular entity.
Suppose, just for example, that their names are remote_schema1, remote_schema2 and remote_schema3.

I have one central site that, via cooperation, mantains a copy of every remote...

I'm very new at db2 i'd like to grant reorg privilege to an user i tried with the following command
db2 => grant reorg on database DB_NAME to USR_NAME;

but it shows following error. can anyone help me on this

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "reorg"...

create sequence A

insert into T1(a,b) values(nextval for A, "data");
insert into T2(a,b) values(prevval for A, "data);

I am running a multiple threads java application.

The first field of table T1 and T2 should be the same if nobody issue a NEXTVAL for A in between.

My question is how can I ensure nobody(other threads, or other DB2 user) can issue a 'nextval for A'...