Now now. This isn't FAKING. This is just a different word for the same thing: CREATE FUNCTION v(a INT) RETURNS TABLE (c1 INT): RETURN SELECT c1 FROM...

Paul Reddin

07-06-2003 07:26 AM
Serge Rielau

Evan, my company provide a federated solution to this with impressive performance. For this reason we have a deal with SAP as an embedded technology...

David Penney

07-05-2003 05:13 PM
David Penney

I'm now using V8.1 for Windows. What happened to the text extender functions? Stan

Stanley Sinclair

07-05-2003 03:56 PM
Stanley Sinclair

I create tables to have fixed-length fields before variable length fields. Now, does it matter in which order the fields are in INSERTs,...

Stanley Sinclair

07-05-2003 03:30 PM
Stanley Sinclair

I wanna use "Similar Sequences Mining" function in intelligent Miner.But it appeared a error message 'from Intelligent miner component "Data Access...

tkw881

07-04-2003 10:35 AM
tkw881

Greeting all, DB2 Ver 7.2 I have installed with the IBM DB Connect on the local database OS/2 in order to set the remote database access to AS/400....

Uthuras

07-04-2003 10:10 AM
Larry

Hi, I have two tablespaces : TS_USR_DAT => Contains user data TS_USR_IND => Contains the indexes There are quite a few tables which...

CompGeek

07-04-2003 02:17 AM
Fabrizio Napolitano

Did you try implicit_schema with a non-existant schema name? this should work and give you Control privilege if i remember correctly. PM "Kota"...

Kota

07-03-2003 05:13 PM
PM \(pm3iinc-nospam\)

Only thing i can think of is looking for something...

PM \(pm3iinc-nospam\)

07-03-2003 04:34 PM
PM \(pm3iinc-nospam\)

hello , can someone provide me the doc about the access plan explaination? i couldn't understand the db2exfmt.out file. thanks

xixi

07-03-2003 03:40 PM
PM \(pm3iinc-nospam\)

That's why I hate GUIs... ;-) -- Larry Menard IBM Workstation Database (DB2) Performance Team Defender of Geese and of All Things Natural "Rhino"...

Rhino

07-03-2003 03:40 PM
Mark A

hi, i try to use sql optimize for n rows to speed the performance , so i try to use db2 explain to get the access plan to compare with and without...

xixi

07-03-2003 03:38 PM
PM \(pm3iinc-nospam\)

Hi, Change the value of DESCSTAT from NO to YES and reassemble DSNZPARM. Vesna Frank wrote:

Vesna Martinovic

07-03-2003 02:45 PM
Vesna Martinovic

Hi Folks, We are running DB2 UDB EE 7.2 on WIN2000. The project is migrating previous SQL Server 2000 to current DB2 Server using IBM MTK. It's...

cat

07-03-2003 02:38 PM
cat

Hi, I have installed the Distributed Debugger 9.2 on my PC with ESE 8.1 FP2 and db2set DB2ROUTINE_DEBUG=on (instance has been recycled). However, a...

Jean-Marc Blaise

07-03-2003 12:38 PM
Jean-Marc Blaise

Any idea? Checked the java.zip and all possible things. (Wed Jul 1 22:02:01 2003) pid= 44388 getBufferCount(): Error during recv, einfo= 73 (client...

Kota

07-03-2003 09:41 AM
Kota

Yes, we are still working on Kerberos support for DB2 on AIX. Perhaps we can ship this next year. No promises, however. Tom Remmers wrote:

Blair Adamache

07-03-2003 09:32 AM
Blair Adamache

Hi all. In db2diag.log I found next record 2003-07-03-13.21.46.812000 Instance:DB2 Node:000 PID:2096(db2dari.exe) TID:3144 ...

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

07-03-2003 08:57 AM
Sean McKeough

Is there a way to setup a stored procedure to do a runstats on a given table name? "Larry Menard" <lmenard (AT) ca (DOT) ibm.com> wrote

xixi

07-03-2003 07:51 AM
Larry Menard

Hi I want to see how often individual stored procedures are being called. Does anybody have any ideas how I could achieve this? (Running 7.2...

Tim Jacobs

07-03-2003 07:05 AM
Sean McKeough

Hi Blair, No I am not. I just did db2start, then 3 call procs from the same session. 1st one takes 1.3s, 2nd one takes 0.2s, 3rd one takes 1.3s (new...

Sean McKeough

07-03-2003 07:04 AM
Sean McKeough

Hi Everyone, Recently our comany upgraded their applications from MS ACCESS 2000 to DB2 version 7.2 UDB. I'm not as skilled in DB2 with the...

sharads

07-03-2003 04:04 AM
Knut Stolze

I need to get the max # from the following row values based on a portion of the data: abcXXX01 abcXXX02 defXXX03 abcXXX04 abcYYY01 defYYY02 ghiYYY03

Jim

07-03-2003 03:55 AM
Knut Stolze

Hi Ulf, which version of java do you use? Because someone find out, that java 1.4. doesn't run with db2 v8.1 ! So it's quit better if you use java...

savas

07-03-2003 02:51 AM
savas

I'm awfully confused. You talk about DB2 on Linux, but your error message is from MS SQL Server on Windows, reporting problems with the IBM CLI...

Mark Yudkin

07-03-2003 01:05 AM
Mark Yudkin

Hi everybody.I'm Facing a ploblem to calculate running average.I am explaining the scenario. In my table there are two column only 1.Name 2.Marks. In...

Arijit Chatterjee

07-02-2003 11:51 PM
Ian D. Bjorhovde

Whenever we try to do a summary table refresh, DBAgent.executeQuery(), REFRESH TABLE inst1.product COM.ibm.db2.jdbc.DB2Exception: SQL0911N ...

Kota

07-02-2003 08:02 PM
Ian D. Bjorhovde

On Tue, 1 Jul 2003, Robert Eigner wrote: It sounds like you're doing inserts without using parameter markers, i.e. your query is similar to "insert...

Robert Eigner

07-02-2003 07:56 PM
Ian D. Bjorhovde

hi, i am trying to create index, but looks like i can do this create index AXDLIB.AXWZWL02 on AXDLIB.AXWZW ( ZWKMCD ASC) create index...

xixi

07-02-2003 06:09 PM
xixi

The link you referred to offerred a great deal of details on Using Import to Recreate an Exported Table The url is too long and got cut off. I try...

Trent

07-02-2003 05:53 PM
Trent

SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030 i have to recover my database from a backuped node directory - is it...

news_account

07-02-2003 03:55 PM
news_account

Hi Seaching throught DB2 docs, i found that its possible to do the same steps that db2mscs v7 do behind scene on common instaces, but i didnt found...

Alexandre H. Guerra

07-02-2003 10:03 AM
Alexandre H. Guerra

On 1 Jul 2003, Kenjis Kaan wrote: LOAD is not an SQL statement, it is a command. Therefore it can't be executed via DBI (or JDBC, ODBC, etc). You...

Ian D. Bjorhovde

07-02-2003 09:17 AM
Blair Kenneth Adamache

Hello, everyone. Which of the following is being kept in the new table? Check constraints Catalog statistics Primary key definitions

Trent

07-02-2003 12:33 AM
PM \(pm3iinc-nospam\)

arijitchatterjee123 (AT) yahoo (DOT) co.in (Arijit Chatterjee) wrote in message news:<ea01504d.0306241820.60a3262a (AT) posting (DOT) google.com>...

Arijit Chatterjee

07-01-2003 09:51 PM
Arijit Chatterjee

Hi, I am trying to invoke external JavaUDF method from a DB2 trigger. trying one basic program. this is what i did, 1.create...

madhu

07-01-2003 09:51 PM
Serge Rielau

hi, i am using db2 udb v8.1. our application needs to dynamically generate table on run time, then insert data, then using this table to do select...

xixi

07-01-2003 06:48 PM
sathyaram_s

hi , i am using sql create table xxx like aaa including indentity to copy a table , but if table aaa has primary keys specified and xxx has the same...

xixi

07-01-2003 05:30 PM
xixi

I did find quest central but whenever I download it, get a corrupted trial version. Does anyone know of a good DB2 tool which helps rewrite the query...

Kota

07-01-2003 05:05 PM
Kota

"Kenjis Kaan" <tivolinewbie (AT) canada (DOT) com> wrote You need to start reading the manuals. You can get them...

Mark A

07-01-2003 03:55 PM
PM \(pm3iinc-nospam\)

I will highly appreciate any help on below error. The senario is: when I tried to stop/start instace it gives error "SQL1042C An unexpected system...

Jamshaid

07-01-2003 03:35 PM
Blair Kenneth Adamache

Three options I can think of right away: 1) UPDATE T SET ... WHERE T.pk = (SELECT pk FROM T FETCH FIRST ROW ONLY); 2) CREATE VIEW v AS SELECT...

Serge Rielau

07-01-2003 11:55 AM
Brien Schultz

I have a similar problem. I get this Invalid Conversion error occasionally (no clue when). But once the code throws this exception, it does it for...

rajkonduru

07-01-2003 11:10 AM
rajkonduru

"Paul Reddin" <paul (AT) abacus (DOT) co.uk> wrote like SYSIBM.SYSRELS. If you try, you get this error: SQL0607N "CREATE INDEX" is not defined for...

Rhino

07-01-2003 03:45 AM
Paul Reddin

I've been writing A LOT of Java SPs for DB2 and I'm depressed about the execution times I'm getting. Even in the compiled mode they're still running...

Brien Schultz

06-30-2003 11:38 PM
Brien Schultz

We reclaimed first place on 100 GB TPC-H as well: http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=&version=2 What's the fastest...

Gert van der Kooij

06-30-2003 09:24 PM
Blair Kenneth Adamache

Small question, if my runstats are up to date, can I then determine how many pages a certain index is using by looking at the NLEAF value for that...

Erik Hendrix

06-30-2003 07:57 PM
Rhino

I believe on the Redbrick list they discussed this. Have you tried posting this question with them? They're at "redbrick-list (AT) iiug (DOT)...

Brice Avila

06-30-2003 06:13 PM
Aakash Bordia

Hi, I'm writting a stored procedure with several mallocs in it. The first ones work fine but after a point, doing a malloc makes the...

Benji

06-30-2003 05:29 PM
Benji

Hi, I am currently running WAS 4.0.4 with DB2 7.2 fp 7. I have 2 db2 instances with my DB2. I've noticed that after my server goes down and I reboot...

Melba Chu

06-30-2003 04:22 PM
Melba Chu