Hello to everyone, I'm currently doing some UDF and stored procedure development in DB2 v.9. I have a problem with the following construct: SET...

Szymon Dembek

06-12-2007 05:29 AM
Serge Rielau

Hi ppl, The requirement is to load a table from a dataset which has data in comma separated format.The data in the PS file looks something like...

kimi

06-12-2007 04:57 AM
kimi

Hello, I have a db2load script I'm using to populate a large table. Ideally, my target table is required to have "Not Null" constraints on a number...

yeoj13@gmail.com

06-11-2007 04:38 PM
tommaso.gastaldi@gmail.com

Hi, I am using DB2 Enterprise v9 and I had the install done to make the server use Windows Authentication. I would like to get the DB2 Server to use...

ravlinxer@gmail.com

06-11-2007 04:20 PM
ravlinxer@gmail.com

Hi All, Is there any particular advantage in having larger page sizes for data warehousing environment over smaller pagesizes. For example, is it...

Asphalt Blazer

06-11-2007 02:22 PM
Ian

Hello, We have turned on INTRA_PARALLELISM and also bumped up sort heap ten times. are there any other suggestions with turning on INTRA_PARALLELISM...

db2admin

06-11-2007 02:19 PM
Ian

Previously posted on comp.databases.oracle.misc. Apologies to those who read both groups. I have created a link using generic connectivity from an...

ahogan

06-11-2007 06:10 AM
ahogan

Hi all. I'm writing a performance analysis utility that uses the snapshot monitor C API to get statistics in the connection level. It seems that the...

Yaron Goldstein

06-11-2007 02:54 AM
Yaron Goldstein

Hi All, I am getting this error Package "NULLID.SYSLN30F 0X5359534C564C3031" was not found in my application, Application is a Websphere portet...

Prassi

06-11-2007 01:16 AM
Jan M. Nelken

http://groups.msn.com/-netusergroup http://groups.msn.com/-netusergroup Hi all its my .net user group all r welcome to join this groups.And develop...

jinishivs

06-10-2007 03:42 PM
jinishivs

THOMAS GUGGER INDEPENDENT RECRUITER tgugger (AT) sbcglobal (DOT) net 419-537-9447

Tom Gugger

06-09-2007 10:19 PM
Tom Gugger

Hello, I am working with DB2 v9, and I am looking to create a TIMESTAMP column in one of my tables that will automatically insert the...

Jeff Shantz

06-08-2007 11:20 AM
Lennart

Hi, I would like to gtet the unicode value of an character stored in a DB2 UTF-8 database. For example: having the german character "ä" (a with two...

globomike

06-08-2007 10:55 AM
globomike

Hi, This is more of a general question... I have a series of stored procedures (chain of procedures) in db2 on an AS400 which are executed from a...

jer006@gmail.com

06-08-2007 08:17 AM
jer006@gmail.com

New material has been added on software testing including penetration testing, self test software and many...

Madge

06-08-2007 06:12 AM
Madge

Hi All I m trying to use a query that would calculate the table size in MB s rather than pages The query is as follows db2 "select...

Racerx

06-08-2007 04:53 AM
Tonkuma

Hi All: I m using db2 v8 fixpc 12 on aix There is this particular query that i m having a problem with.. The query seems to work fine on windows v8...

Racerx

06-08-2007 12:59 AM
Racerx

Can anyone tell me the URL to download the ifo centre for v9? I've gone nearly blind looking for it. Note to IBM: MAKE THIS STUFF EASIER. Even...

Mairhtin O'Feannag

06-07-2007 05:52 PM
Konstantin Andreev

DB2 UDB v8 on AIX I see that Unicode UTF-8 and USC-2 are only available for version 8. I also thought I saw something that referenced UTF-16 for DB2...

shorti

06-07-2007 05:41 PM
shorti

Hello there. 1) According to documentation, setting CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4) But MAXAPPLS is set to AUTOMATIC,...

Konstantin Andreev

06-07-2007 05:20 PM
Konstantin Andreev

When setting the locktimeout value, is it immediately changed for the database? or will we have to de-activate the db? Or stop / restart db2? Did...

Justin

06-07-2007 03:07 PM
Artur

Hello, I'm posting this casually, with hope that someone can provide a bit of guidance. DB2 has many monitors, health, performance, etc. ...

cjshea@gov.pe.ca

06-07-2007 02:30 PM
swami

I am now using db2 v8.2 64bits without DPF. I want to create a very large table which is about 1000G and the record length is suitable for 32K page...

Woody Ling

06-07-2007 01:37 PM
Haider Rizvi

TesterQA is a Leading Software Testing site www.testerqa.com is a leading testing information site contains Latest testing news, articles,...

TesterQA.ban@gmail.com

06-07-2007 12:55 PM
TesterQA.ban@gmail.com

HI all, Can someone explain this sorting issue? we are using V8 on Windows, but database *might* have been created with V7 (I can find out if it...

apattin

06-07-2007 08:38 AM
Brian Tkatch

I have found an excellent resource on Rational Robot for automated testing providing a complete set of components for automating...

surprise.tim@gmail.com

06-07-2007 06:28 AM
surprise.tim@gmail.com

I have a job that inserts thousands of LOBs into a table. Under a UDB 7.2 client, it runs in four minutes. The same job, running against the same...

Ross Mallett

06-06-2007 08:39 PM
Ross Mallett

Can someone provide me the simple syntax necessary to insert or update to a row containing a single BLOB column, where the BLOB data will be obtained...

shallowpool

06-06-2007 07:30 PM
Ross Mallett

IBM DB2 UDB Is there a SQl query I can send from the web server that will return a list of tables currently in the LOAD PENDING state? LOAD QUERY is...

Mr. DOS

06-06-2007 02:59 PM
Mr. DOS

UDB v8 fp 10 on Unix AIX Have SMS defined tablespace with numerous tables. Many of the tables contain CLOB columns. Short of looking at the all the...

apple

06-06-2007 10:49 AM
apple

db2 8.1 fp13 on Linux for zSeries (64-bit) Every invocation of db2pd except for the "-version" and "-osinfo" options gives following...

Jeroen van den Broek

06-06-2007 10:18 AM
Jeroen van den Broek

I want to trap errors (RI errors), if any, that might turn up during merge in DB2. Is there some feature like the one in Oracle: MERGE INTO... WHEN...

amitabh.mehra@gmail.com

06-06-2007 08:56 AM
Serge Rielau

Rational Robot is a complete set of components for automating the testing of Microsoft Windows client/server and Internet applications running under...

Shiv Kumar

06-06-2007 08:19 AM
Shiv Kumar

I am not sure whether users can access data or insert new data into tables who belong to a rebalanced table space after new containers are added?...

James

06-06-2007 02:44 AM
spider007

Hi I m facing a weird problem when i m executing a procedure with different IDs, The procedure has a select statement , and a codition. when the...

rick

06-05-2007 10:53 PM
db2start@gmail.com

DB21085I Instance "oltp" uses "32" bits and DB2 code release "SQL08027" with level identifier "03080106". Informational tokens are "DB2 v8.1.2.128",...

aj

06-05-2007 10:42 PM
db2start@gmail.com

we have a table with jobs and a table with job_history information. Users can define jobs and let them run every X minutes/hours , like...

jan.marien@gmail.com

06-05-2007 10:41 PM
db2start@gmail.com

I am going to install DB2 version 9 on Windows XP workstation. But I can not continue the installation after I issue the command "setup /i en"....

James

06-05-2007 02:29 PM
Leo Petr

Hi, I'm working as a DB2 UDB DBA. I have some questions regarding SCP command... Actually every week redirect restore takes place from one of...

sat

06-05-2007 09:29 AM
Lennart

What is the best practise to migrate all data in a 4K User tablepace to an 8K User tablespace for DB2 v8.2.7? The idea i am toying with is to...

Otto Carl Marte

06-05-2007 08:15 AM
Sam Durai

Hello, I have a user who regularly runs a query which blocks a lot of other queries. The query is initiated from SSIS (SQL Server...

Troels Arvin

06-05-2007 06:25 AM
Troels Arvin

Dear all, I got a problem on db2 for aix running a high workload messaging system with more than 5,000,000 of deliveries per day. During high peak...

m.gelosa@gmail.com

06-05-2007 06:11 AM
m.gelosa@gmail.com

Hi I am writing a select statement that has an arithmetic function inside a case statement that uses logic to decide whether to divide or multiply...

jer006@gmail.com

06-05-2007 05:37 AM
Tonkuma

Hi, Has anyone used STMM with multiple instances on the same machine in V9? From all the documentation I have read it looks like this should work...

jdokos

06-04-2007 03:15 PM
jdokos

DB2v8.x - AIX64 what status is considered 'idle' by DB2? Connect Completed UOW Waiting I would think statuses like this would be considered 'idle'...

cbielins@gmail.com

06-04-2007 03:14 PM
cbielins@gmail.com

Hi. When I try adding a new partion to a database instance on a 4 processer Linux server I get a time out and a message like "host did not...

Dan van Ginhoven

06-04-2007 12:20 PM
Ian

Hi, I was wondering if there is a way to make the SQLException of the new JCC JDBC driver behave and get a decent message out...

schm4704@gmail.com

06-04-2007 04:03 AM
schm4704@gmail.com

I have a column in a database which saves results from a remote machine which is related to qty on hand. The problem is that qty's are numeric if >...

whitsey

06-03-2007 05:14 AM
Lennart

See the following example. db2 => create table aaa (c1 decimal(10,3)); DB20000I The SQL command completed successfully. db2 => insert into aaa...

James

06-02-2007 01:51 PM
Tonkuma

DSN810.SDSNSAMP(DSNTIJIC) backs up the DB2 catalog. Is there an example out there of how to restore it? Regards, MVSGuy

mvsguy

06-02-2007 01:56 AM
Mark A