Like pocket-size lava lamps, these wide body pens in an array of stunning colors spread peace and joy wherever they appear for more...

faisal4jabbar@gmail.com

05-15-2009 10:44 PM
faisal4jabbar@gmail.com

Never be at a loss for connectivity when you carry this convenient red modem cord winder. for more info http://www.googleiloveu.blogspot.com/

faisal4jabbar@gmail.com

05-15-2009 10:35 PM
faisal4jabbar@gmail.com

Hi Group, Running db2 on iSeries - having a problem with to many open cursers - clrearly a problem in one of many "homemade"-applications. Is there...

Morten Nissen

05-15-2009 05:33 PM
Karl Hanson

Hi, I see that I always get on CLP for CALL stmt: Value of output parameters -------------------------- Parameter Name : Parameter Value : How can...

rnbjrnbj@gmail.com

05-15-2009 11:42 AM
rnbjrnbj@gmail.com

Hello all, I am thinking whether db2 support backup of individual table partition. And also if there has been any thought for rollin/ rollout...

rnbjrnbj@gmail.com

05-15-2009 11:37 AM
rnbjrnbj@gmail.com

Hi All, Was interested to know what is the maximum # of Instances(with databases) you have created on a single server? (LUW v9.5) For...

Test

05-15-2009 11:11 AM
CallMeRay

Hi Friends Please let me know if you are looking out for IBM AIX Trainig in Bangalore. Send me an email to praveenchand.j (AT) rrootshell (DOT) com...

J.P.C

05-14-2009 02:34 AM
J.P.C

Hi all, Is it possible to get / dump the content of locklist? We started to get escalation messages frequently. I am trying to find a...

mxb1c

05-14-2009 12:16 AM
Lennart

A coworker is using a script to copy the logs from the archive log directory. The value of LOGARCHMETH1 is "DISK:/db2archive/". The script is...

Richard

05-13-2009 01:06 PM
Tapio Väättänen

I Backed up and restored my prod DB into another offsite location. Then i federated the db and created a view so the select selects data from both...

db2green

05-13-2009 12:38 PM
Lennart

Hi, Something happened on our standby HADR, which initiated a DB2 install (msiinstaller). I have no idea how it started this but everytime...

db2green

05-09-2009 09:32 AM
Larry

Hi I was using cursor load to load form one table to another. There was an application with anid that read from the source table, with the query...

Arun Srinivasan

05-08-2009 11:50 PM
Ashok

Folks, At IBM some say products don't get delivered, they escape. So as some of you may have noticed the DB2 Cobra is about to do just that. You can...

Serge Rielau

05-06-2009 05:01 PM
Serge Rielau

What are the different methods for encrypting table columns that are inherent to DB2 product (as opposed to application based encryption)? Is there...

Asphalt Blazer

05-06-2009 02:37 PM
Serge Rielau

Hello, A VB 6.0 program that uses ado (NOT ADO .Net) against DB2 9.5 opens a connection with a connection string...

Francisco

05-06-2009 11:17 AM
Francisco

i need your help... i want to implementing a cluster on DB2 but i don't know it's command sql??? is it same with command sql in SQL server, Oracle...

herlan76ban@gmail.com

05-06-2009 10:09 AM
Ian

Second attempt (apologies to those who got the first post before I canceled it) Folks, Below a procedure I wrote upon request which I figure may be...

Serge Rielau

05-04-2009 09:38 PM
Ashish Prasad

Hi, Iam new to this group.I am looking for some help on tuning query's on a dataware house.The datbase is of DB2 version 9.1 Fixpack 2 on windows 64...

paddypl@gmail.com

05-04-2009 03:00 AM
paddypl@gmail.com

Hi, there is a table with items and a table with item descriptions. The descriptions can be in more than one language. Therefore I have...

w.l.fischer@googlemail.com

05-02-2009 05:58 AM
Lennart

hello , i looking for a sample java programme/coding or script to do following: lookup value in column in a table. (eg: 'Y') based on value i need to...

rnbjrnbj@gmail.com

05-02-2009 02:09 AM
Serge Rielau

DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09014" with level identifier "01050107". Informational tokens are "DB2...

bwmiller16@gmail.com

05-02-2009 02:06 AM
Serge Rielau

DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09014" with level identifier "01050107". Informational tokens are "DB2...

bwmiller16@gmail.com

05-01-2009 04:56 PM
Ian

Are there any db2 benchmarks for quad/dual core processors? We will have a dedicated "physical" server for DB2. Would we be better off with two...

mxb1c

05-01-2009 03:25 PM
Mark A

Hi all, We are planning to provide search functionality in our application. The search will run on a CLOB field. Has anyone had a...

mxb1c

05-01-2009 12:08 PM
mxb1c

I will be doing two classes in connection the YAPC (Yet Another Perl Conference) 10th Anniversary conference at Carnegie Mellon University in the...

--CELKO--

04-30-2009 03:59 PM
--CELKO--

Hi guys Some may find this utter madness some may be ridiculed. But I have a doubt. I have one table arun.test1 ( icn varchar(20), icn_sub...

Arun Srinivasan

04-30-2009 02:41 PM
Ian

I keep getting the following error message when calling a test java stored procedure. C:\Users\Eric>db2 call insert_javasp('AAA') SQL4304N Java...

Eric Davidson

04-30-2009 10:52 AM
Eric Davidson

Hi. Faced strange thing in DB2 9.5. I just noticed that TIMESTAMP(GENERATE_UNIQUE()) returns timestamps in April 24 while current time on computer...

Dmitry Bond.

04-30-2009 09:42 AM
Serge Rielau

How does DB2 convert the precompile timestamp to a HEX contoken? Willie Favero in a post had said "...DB2 does a shift logical to the timestamp then...

chuck

04-29-2009 10:40 AM
chuck

How does DB2 convert the precompile timestamp to a HEX contoken? Willie Favero in a post had said "...DB2 does a shift logical to the timestamp then...

chuck

04-29-2009 09:00 AM
chuck

Hi all, after searching for hours I couldn't find a solution (if any) for my problem. I want to store binary data (octet strings without...

McA

04-28-2009 11:08 AM
McA

Is there a SQL query to retrieve server full hostname or IP address. Something like select current server as server from sysibm.sysdummy1 Thanks.

Sawan

04-28-2009 06:56 AM
Sawan

db2pd -mempools -alldatabases -inst => Sum of PhsSz = 9GB db2pd -memsets -alldatabases -inst => Sum of Used = 9GB db2mtrk -i -d -p -v => Sum of...

Klemens

04-27-2009 11:51 AM
lfinnie@ca.ibm.com

All, I have two machines running a few HADR paired databases which are managed by TSA (configured through db2haicu). I have one application that...

Frederik

04-27-2009 03:47 AM
Frederik

I found the following: http://nocoug.org/SQLchallenge/FirstSQLchallenge.pdf at http://nocoug.org/ which is an Oracle User Group. Personally...

Lennart

04-27-2009 02:38 AM
Lennart

Hello, I want to know few things about express-C. Does it support any parallelism,since if you have 2 processor support and no...

rnbjrnbj@gmail.com

04-26-2009 05:47 PM
Serge Rielau

Hi everyone, I am a software developer looking at database solutions. I presently make use of Microsoft Access for a lot of things, but am beginning...

k.hurren@live.com

04-24-2009 11:06 AM
Scott Sobotka

We run a web based service with db2 as the data storage mechanism. What we would like to do is locate a hot standby machine in another state with...

robert stearns

04-24-2009 03:50 AM
jmueller

Hello, I need automatic conversion of types like those of Informix, Oracle and SQLServer where sentences like SELECT * FROM MYTABLE WHERE...

Francisco

04-23-2009 07:23 PM
Serge Rielau

In V9.1 according to the documentation, the online backup is compatible with DDLs that require a Z lock (such as ALTER TABLE,...)... Online DMS table...

tg

04-22-2009 02:55 PM
tg

I ran a load and it crashed in the middle of index rebuild due to unavailability of free space in file system. I terminated it, and on simple query...

Arun Srinivasan

04-22-2009 12:48 PM
Pierre StJ

I ran these statements and expected that the snapshot for dynamic sql would return nothing. Why am I getting data in the datamart.out file? db2...

Justin

04-22-2009 11:28 AM
Mark A

Hello, I'm having trouble setting up a nickname on a DB2 v. 8.2 server to a table on DB2 v. 9.5 server. Does someone know if there's a limitation...

Troels Arvin

04-21-2009 04:08 PM
Troels Arvin

Hi, I want to know if there is a way to find out the least size of bufferpool while maintaining high hit ratios. please advise.

db2admin

04-21-2009 03:42 PM
Ian

I have been using the db2 sql interface for years and I've always found it difficult to use. I looked around the web and found a web based database...

markd1217@gmail.com

04-21-2009 01:48 PM
markd1217@gmail.com

I migrated a DB2 ESE V8.0.4 on Solaris with Replication server to version 9.5. The Solaris Sparc System is the Replication Target. After the...

heirobebe

04-21-2009 09:51 AM
heirobebe

Folks, I just scribbled up this procedure for someone and figured it may be useful for more than a one-of use. What is does is produce a series of...

Serge Rielau

04-21-2009 05:33 AM
Serge Rielau

Gregor Kova� wrote: supposed to throw -804s Could it be you used a DB2 9.1 IMPORT command against DB2 9.5 or so? Cheers Serge PS; See you next...

Serge Rielau

04-21-2009 05:23 AM
Serge Rielau

When acquiring a User-Count based DB2 EE license, minimal 25 users have to be purchased. How does it relates to sub-capacity licensingm can these...

bdh002

04-20-2009 03:09 AM
bdh002

Standard prologue - I have read the documentation available to me and have been unable to find the answer to my problem. How do I avoid GRANTing...

n61601@gmail.com

04-17-2009 10:02 AM
n61601@gmail.com