I have 2 database both was full backup from V7.2 fax pack 8 Database "one" can be restored to V8.1 without the need to migrate to Database "two"...

Tony Do

08-29-2003 09:20 PM
ashok

Hi How do I find all the tables in a schema, are in check pending state? I don't want to use Load Query on every table. Is there anyway to find it...

Prakash

08-29-2003 08:31 PM
ashok

"George McLean" <gmclean (AT) rrsytec (DOT) com> wrote before the point in time the update occurred, and then roll the logs forward from the backup...

Mark A

08-29-2003 05:13 PM
Mark A

I've seen the following several times in .def files: LIBRARY foo EXPORTS foo@24 foo = foo@24 What is the @24 for? Thanks!

Wendy Powley

08-29-2003 04:08 PM
Wendy Powley

Hello, When DB2 tables have fragmentation you issue a reorganize table command as follows. db2 reorg table myschema.my_table use temp_4k Does the...

Wood,Shannon

08-29-2003 04:01 PM
Mark A

Hi everybody, I need some help in DB2 (Version 7/8). I am looking for a command that will "Drop all Schema" in a database. Can anyone help...

Sabrina

08-29-2003 02:23 PM
Markus

Only two types of salespeople call their customers "users" - drug dealers and software vendors. Mark Townsend wrote:

Blair Adamache

08-29-2003 01:06 PM
PM \(pm3iinc-nospam\)

We currently have a DB2 7.2 FixPack 3 (FP3) database and we are migrating toward version 8.1. Here is my current understanding of the steps needed...

milkchaser

08-29-2003 12:49 PM
milkchaser

Trying to help a friend out with this issue, I am not the DBA on this ..... Whenever we import data (using the DB2 command "import"), we should get...

M. Krafick

08-29-2003 10:42 AM
M. Krafick

Hello all, Is there any one using veritas do the online db2 backup on routine basis? how to set the policy for mutiple retention ? If I need to have...

denny qian

08-29-2003 10:03 AM
cchattoraj

Regards! After installing Fixpak 10 on DB2 V7.2 (FP3, AIX 4.3.3) and migrating the instance to the new Fix level, the instance owner is unable to...

Damir Wilder

08-29-2003 08:45 AM
Nenad

HIi all, Trying to execute the following code within a procedure: DECLARE CONTINUE HANDLER FOR SQLSTATE 'WW033' GOTO create_batch; .....some...

Derek Clarkson

08-29-2003 12:22 AM
Matthew Emmerton

Anyone have the beta version of Integration Integrator or Xperanto that you could provide me? I really appreciate your help. Ali

Ali Kamal

08-28-2003 08:27 PM
Larry

What are the most important enhancement on the application development side in V8 ? BTW, we use Websphere-DB2 in our application Thanks

janagana

08-28-2003 07:21 PM
janagana

I have had a significant upgrade in RAM on our server and may have up to a GIG of memory that I can reallocate to my DB2 bufferpools. My problem is,...

M. Krafick

08-28-2003 04:51 PM
Kristi Close

hello All, Is there any one using veritas netbackup db2 edition do the online db backup? I'd like to learn some practice experience for you. It's...

denny qian

08-28-2003 04:11 PM
denny qian

Thanks Ian. We DL'd the trial version, and I think it's going to work out for us. It's processing an UNDO SQL statement right now. -corky Ian D...

corky

08-28-2003 03:31 PM
corky

Hi to all NG I have one question for db2 version 7.2. How to call a store procedure written in SQL from java application using JDBC. Best...

John Smith

08-28-2003 01:05 PM
Sean McKeough

I am currently using the 7.2 DB2 client with its Type 2 ("app") JDBC driver. We are switching to 8.1 with its all-Java "universal" JDBC driver. ...

milkchaser

08-28-2003 12:24 PM
Kai-Uwe Klavei

Hi, I am try load data with delimiter : in db2 dub v8.1 fp2 on solaris .. I am getting fowwing error , let me know is there any proble with...

Lekharaju Ennam

08-28-2003 11:16 AM
Lekharaju Ennam

What is the difference between the run-time, application developer and administration clients? I am mostly writing java apps that will use the...

milkchaser

08-28-2003 10:35 AM
Blair Adamache

we are using MS 2000, with version 7.2 DB2. I also noticed the following statement from DB2 online doc: "Adding a column to a table will result in...

kevin

08-28-2003 10:34 AM
kevin

LO For a professionnal project i have to work with DB2 data returned by COBOL services. These COBOL services take several blocs in input and...

FlorentL

08-28-2003 09:34 AM
FlorentL

Hello, I would like to make history database using triggers and I get a following error executing such code: CREATE TRIGGER piotr.rec_hist AFTER ...

Piotr

08-28-2003 06:12 AM
Piotr

Are rebinds necessary after applying client fixpacks? The README document seems to be suggesting a rebind against each database. Does that mean if I...

Lamimi02

08-28-2003 02:43 AM
Lamimi02

This is a 7.2 database. I am trying to test this, but having resource troubles, and running out of time. I want to delete rows...

ScottHW

08-27-2003 05:54 PM
Christian Maslen

PID:6830(db2agent (xxxxx)) Appid:*LOCAL buffer_pool_services sqlbinit Probe:245 Database:xxxxx WARNING: extended storage (estore) is turned...

andreyp#Antispam@mapsitnA#e-vision-group.com

08-27-2003 03:22 PM
Blair Adamache

"N. Shamsundar" <shamsundar (AT) uh (DOT) edu> wrote How is GRANT CONNECT going to help me change the users password? By access I mean the users...

FBT

08-27-2003 01:57 PM
FBT

Hello, where can I find some tutorial, help, samples about writing triggers in DB2 ? Regards Piotr

Piotr

08-27-2003 11:37 AM
Blair Adamache

Hi If I create table as instance owner as follows: create table someuser.junk(x int) What privileges will someuser have. I just tested that...

keith

08-27-2003 10:55 AM
Ian D Bjorhovde

I would like to be able to connect to DB2 on OS/390 from an AS/400 system. I am familiar with the various techniques for connecting to mainframe DB2...

Andrew Watson

08-27-2003 10:31 AM
Kent Milligan

Hello all, I'm trying to connect a Linux machine (Redhat 8.0) to a IBM iSeries running os400 V5R1. I installed IBM(R) DB2(R) Universal...

Douglas Hunter

08-27-2003 08:50 AM
Karl Hanson

What would be a neat (i.e. reasonably efficient) way of splitting paragraphs of text? E.g splitting VALUES ('I would, if possible, like to see a...

Paul Vernon

08-27-2003 07:09 AM
Paul Vernon

This will do micro seconds. Divide by 1000 to get milliseconds... CREATE FUNCTION F.MICROSECONDS (X TIMESTAMP, Y TIMESTAMP) RETURNS BIGINT SPECIFIC...

Rudolf Bargholz

08-27-2003 06:53 AM
Paul Vernon

Is it a single db partition or multiple db partitions db server? If it is EE, you can turn on INTRA_PARALLELISM. Regards, FRX allenj (AT) ndr (DOT)...

Fan Ruo Xin

08-27-2003 06:43 AM
Paul Vernon

Hi, I used DB2's bulk loader "load" to import large amount of data into a temporary table. From there I want to move the data into another...

Toralf Kirsten

08-27-2003 06:42 AM
Joachim Klassen

Hello, We have an urgent assignment with one of our MNC client.They are looking for candidates having 2+ yrs experience on DB2 DBA.If you or any of...

pranita

08-27-2003 12:55 AM
pranita

Hi, When I try to run/compile the following SQL PL, I get errors for the DDL statements used in them. For example, the GRANT and DROP statements...

Thomas Theakanath

08-26-2003 07:35 PM
Thomas Theakanath

I'm trying to perform an EXPORT from a DB2 for OS/390 table followed by an IMPORT against to another DB2 for OS/390 table from a command window on a...

Perry R Shindle

08-26-2003 06:18 PM
Matthew Emmerton

Hello I was needing to connect a v8 client fp2 to a v7 server fix 10, and after the configuration when trying to use the application, a...

Alexandre H. Guerra

08-26-2003 05:32 PM
Alexandre H. Guerra

Sean McKeough <mckeough (AT) nospam (DOT) ca.ibm.com> wrote Thanks again. I'll try to push this requirement through your normal channel. Is it...

minjie

08-26-2003 03:14 PM
minjie

Hi, Please help me with the following Oracle-to-DB2 migration issues: 1. Are there any DB2 equivalents for the functions in Oracle built-in package...

Thomas Theakanath

08-26-2003 12:03 PM
Blair Adamache

Hi, is there a way to set a field-seperator for the output? I have to get a row of fields which also can contain spaces. So the blank for...

Kai Baumgart

08-26-2003 10:56 AM
Anton Versteeg

DB2 v8 FP2 WE Red Hat AS 2.1 For a caching mechanism that I am writing, I need the date/time a table was last changed with an INSERT, UPDATE or...

allenj@ndr.com

08-26-2003 10:34 AM
allenj@ndr.com

Anyone know where I can get information on connecting Perl4 to DB2? I know its easy with the newer version of perl, but I have a need to use Perl4...

Kenjis Kaan

08-26-2003 08:49 AM
Philip Nelson

Hello All I have a problem with an SQL query. The query is quite simple cause i need to get all the rows of a table which have a field set to...

Kiavik

08-26-2003 06:14 AM
Anton Versteeg

I am trying to run XA in a App Server using UDB 8.1 Fixpack 0 on Windows. I see the UnsatisfiedLinkError in the log file. Some posts have mentioned...

Prashant Ponnala

08-26-2003 03:35 AM
Prashant Ponnala

Hello everybody, I'm getting the follwing error when I start db2expln or dynexpln. I have install DB2 V8.1 without FP on Windows XP. Also I have...

Stefan M. Mihokovic

08-26-2003 02:45 AM
Stefan M. Mihokovic

Hi Rhino, Thanks for the reply. Let's forget about the 'SQLSTATE=HY507' message. I would like to concentrate on the CLI0157E error message. As...

SAP BASIS Consultant

08-26-2003 02:02 AM
Mark Yudkin

ceprnatwork (AT) hotmail (DOT) com (the dragon) wrote in message news:<6e59cc25.0308200651.6edb0e2 (AT) posting (DOT) google.com>... I dont know why...

Lennart Jonsson

08-25-2003 11:41 PM
Lennart Jonsson