| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Provide instant content that benefits your customers and reduce the
load on your customer support team. You also get free user generated
content....
michael moody
|
01-30-2012 06:15 AM
michael moody  | 0 | 3 |
| | | In DB2 9.5.8 on AIX, I have come across a bad query plan that is to
some extent caused by the optimizer wrongly estimating the initial
NLJOIN...
Oliver Schoett
|
01-28-2012 05:17 AM
Lennart Jonsson | 7 | 8 |
| | | I'm using SPSS to query a DB2 database and I get this error:
SQLFetch (getting tables) failed : CLI0165E Error in
row. SQLSTATE=01S01
The weird...
Greig
|
01-27-2012 05:21 PM
Helmut Tessarek | 2 | 3 |
| | | Hello all,
DB2 v9.5 fixpack 5 LUW.
I need insert values on a federated table using a trigger.
Is that possible?
Actually, I´ve got this SQL ERROR...
Bruno Almeida
|
01-27-2012 05:02 PM
Lennart Jonsson | 3 | 4 |
| | | Here's a fun one.
Instance owner can see/use a local database name:
-------------------
db2 => connect
connect
Database Connection Information
Peter H. Coffin
|
01-25-2012 05:06 PM
TheBoss | 6 | 7 |
| | | In an sqx file, I am able to declare a standard cursor. But the
database option is failing.
Example:
DECLARE STDDEMO CURSOR DATABASE source USER...
Kdawg
|
01-25-2012 11:17 AM
Frederik Engelen | 3 | 4 |
| | | Recently I am trying to new stored procedure MONREPORT to investigate
the performance issue. I get the following result and can't figure...
Arthurccc
|
01-24-2012 04:45 PM
Helmut Tessarek | 1 | 2 |
| | | We have a C++ program that I am updating. There are two sqx files
(one for each db that the app connects to). SQX A has a cursor that
works as...
Kdawg
|
01-24-2012 11:38 AM
Kdawg | 1 | 2 |
| | | I do a lot of LOADing CSV records from Rexx using the ADMIN_CMD to perform the load. The load works just fine but after every successful load I get...
Fin
|
01-21-2012 09:40 AM
Mark A | 3 | 4 |
| | | Hi All,
has anyone got a working example of a SQL-PL dynamic cursor.
TIA
Bill
An unexpected token "FOR" was found following "c5')". Expected...
wfs
|
01-20-2012 05:30 PM
Frederik Engelen | 7 | 8 |
| | | Dear Friends,
Please let us know if you are interested to join CLOUD
Administration(Solaris,networking,SAN and VMware) program.
You can reach us...
praveen.j@rrootshell.com
|
01-20-2012 06:36 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | Hello fellow DB2-ers!
Here are the first few lines of a PROCEDURE: my_procedure:
create procedure my_procedure(
in a_p_id bigint,
in a_region_id...
gimme_this_gimme_that@yahoo.com
|
01-18-2012 05:23 PM
CRPence | 5 | 6 |
| | | Hello
I'd like to update the values of av.score_no to 0 where the value of
pe.avail_flag='Y'
and pe.person_id=av.person_id
Could some kind person...
gimme_this_gimme_that@yahoo.com
|
01-18-2012 04:02 PM
gimme_this_gimme_that@yahoo.com | 2 | 3 |
| | | Hi Everyone ,
I have a DB2 V9.1 server running on AIX which has 8GB of memory .
svmon output shows the memory is completely used as given below
Gladiator
|
01-18-2012 12:36 PM
Ian | 1 | 2 |
| | | I noticed that on some of my DB2 Linux 9.7.4 databases, locktimeout and deadlock errors are written to
the db2diag.log as warning messages, but on...
Mark A
|
01-17-2012 08:03 AM
Mark A | 4 | 5 |
| | | Global Business Intelligence (BI) software vendor, Yellowfin, has
released a new white paper that explores the need for, drivers and
potential...
janette.pelletier@yahoo.com.au
|
01-11-2012 07:28 AM
janette.pelletier@yahoo.com.au | 0 | 1 |
| | | I'd like to update six rows of table "scores" at once using a "with"
and a "(values" construct as shown below.
Actually I'm open to any construct...
gimme_this_gimme_that@yahoo.com
|
01-07-2012 08:45 PM
Tonkuma | 2 | 3 |
| | | Hi,
Table on iSeries has CCSID 13488 (I used DSPFD command to check),
system values on OS are:
QCCSID -
Coded character set
identifier . . . . . : ...
tom
|
01-05-2012 02:54 PM
TheBoss | 1 | 2 |
| | | Dear Friends,
Please let us know if you are interested to join SAN Administration
program. You can reach us @040-66616704.
For further details log...
praveen.j@rrootshell.com
|
01-05-2012 06:27 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | HI,
I was asked to do the performance tuning for the new application .
the problem is there is really little data in test environment .
since there...
esther
|
01-03-2012 11:47 PM
Larry | 1 | 2 |
| | | Dear Friends,
Please let us know if you are interested to join EMC VNX Unified
Storage Implementation with Recovery point. You can reach us...
praveen.j@rrootshell.com
|
01-02-2012 02:11 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | Dear Friends,
Please let us know if you are interested to join EMC VNX Unified
Storage Implementation with Recovery point. You can reach us...
praveen.j@rrootshell.com
|
01-02-2012 02:11 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | Please let us know if you are interested to join SAN Administration
program. You can reach us @044-42187732..
For further details log on to our...
praveen.j@rrootshell.com
|
12-30-2011 07:42 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | Dear Friends,
Please let us know if you are interested to join SAN Administration
program. You can reach us @040-66616704.
For further details log...
praveen.j@rrootshell.com
|
12-30-2011 03:33 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | I noticed several OID files that seemed to correspond to load
failures.
The OID files were located at...
Justin
|
12-28-2011 01:37 PM
Frederik Engelen | 1 | 2 |
| | | Hello ,
We have an issue on one our production DB .
db2_all command doesnt work and gives "connection refused " error.
Everything looks fine ....
Gladiator
|
12-27-2011 03:19 PM
Helmut Tessarek | 2 | 3 |
| | | Dear Friends,
Please let us know if you are interested to join SAN Administration
program. You can reach us @040-66616704.
For further details log...
praveen.j@rrootshell.com
|
12-23-2011 02:56 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | It appears as if it matters how constraints are added to a table, when
it comes to optimizing a plan. Any thoughts on this:
db2level
DB21085I ...
Lennart Jonsson
|
12-21-2011 05:09 AM
Lennart Jonsson | 0 | 1 |
| | | Hello,
... I presently run the DDL below on my Windows XP platform using a CMD
file containing:
DB2 -TVF ZJDDLDAT
... where ZJDDLDAT contains...
Graham Hobbs
|
12-15-2011 06:59 PM
Graham Hobbs | 4 | 5 |
| | | Hi folks, urgent problem here.
I just yesterday upgraded from Express-C 32-bit on XP SP3 9.7.4 to 9.7.5 and all of a sudden I have errors pouring...
Fin
|
12-13-2011 04:39 PM
Fin | 11 | 12 |
 | | I know that beginning 9.5, file system caching is turned off by
default. Our software-app platform is at db2 9.1 windows 2003 due to
installed app...
bostonibd
|
12-11-2011 04:54 PM
Kevin C | 37 | 38 |
| | | Hello,
I am a little bit confused about DB2 temporary tables. (We use MS SQL
Server 2005 at work and we are planning to migrate to DB2.) In MS...
mattes
|
12-10-2011 09:02 PM
CRPence | 1 | 2 |
| | | Using Express-C 9.7.5 64 bit on Win 7 Pro sp1 I am trying to drop the existing tools catalog in one of my databases as i am having all manner of...
Fin
|
12-10-2011 05:53 PM
Helmut Tessarek | 9 | 10 |
| | | For a statement that is compiled once, how can prep_time_worst <>
prep_time_best?
select num_compilations, prep_time_worst, prep_time_best...
Lennart Jonsson
|
12-10-2011 05:34 AM
MarkB | 7 | 8 |
| | | Hi!
I have a problem defining ODBC connection to DB2 from CentOS 6 (Linux
based on Redhat). I'm almost sure that I've done everything as it
should...
newtilus
|
12-08-2011 01:33 PM
newtilus | 0 | 1 |
| | | I'm running an ALTOBJ to make a "not null" column nullable. When I
run it, it starts a database backup into ./sqllib/tmp which ultimately
fills up...
Richard
|
12-04-2011 10:33 PM
Yonghang Wang | 1 | 2 |
| | | Hello,
Have searched for an explicit answer to my COBOL/CICS programming
problem.
- on a CICS screen a user enters a key to select a row which...
Graham Hobbs
|
12-03-2011 09:03 PM
CRPence | 18 | 19 |
| | | Hi all,
My app currently supports Windows OS including XP, Vista and 7 and
I'd like to expand to support Mac as well and is in the process...
justaguy
|
12-01-2011 05:35 PM
Yonghang Wang | 8 | 9 |
| | | Pass-thru result set?
I have a procedure that takes some input parameters and returns a
result set. What I would like to do now is have a wrapper...
esmith2112
|
12-01-2011 02:05 PM
Serge Rielau | 1 | 2 |
| | | Can someone please explain the difference between the following;
db2expln -d mydb -u myuser mypw -o outputfile -q "select * from
mytable"
and
db2...
Wendy
|
12-01-2011 11:49 AM
Helmut Tessarek | 3 | 4 |
| | | Hello,
anyhone has accessed DB2 from LibreOffice Base ?
If yes, could you give me some advece about JDBC connections parms?
(jdbc string and other...
Mario Sacco
|
11-30-2011 09:09 PM
Will Honea | 2 | 3 |
| | | Hi
I placed the 'how' in the subject just to not mislead users as to
contain info on how to do that. I am curious as to make a cluster
using 2-3...
Arun Srini
|
11-28-2011 03:54 PM
Ian | 1 | 2 |
| | | Hello group.
Using db2 9.1 FP9 on windows …
A create index statement is creating an exclusive lock on a table.
The table is fairly big. It has...
oldcapecod
|
11-26-2011 06:43 PM
oldcapecod | 0 | 1 |
| | | Hi,
I'm working on a porting project: an old native Oracle Database
application will be converted to IBM DB2 (task quite finished).
My environment is...
NEXUZ6
|
11-23-2011 03:08 PM
Lennart Jonsson | 4 | 5 |
| | | I found this post
http://groups.google.ca/group/comp.d...5694324f276587
which sounds very promising, but I'd like a more explicit example.
That is, I...
helmuterik
|
11-21-2011 09:17 AM
Lennart Jonsson | 6 | 7 |
| | | My employer will be upgrading from DB2 LUW v8.2 to DB2 LUW v9.7 as
part of a Websphere Commerce migration. I have been asked about pros
vs cons of...
C Huntoon
|
11-18-2011 05:15 PM
juraj.hrapko@gmail.com | 4 | 5 |
| | | Hello,
There is a project at my company to migrate a large, critical
application from DB2 Z/OS to either SQL Server or DB2 LUW. I would
assume that...
jdokos
|
11-16-2011 02:30 AM
Helmut Tessarek | 1 | 2 |
| | | I'm looking to obtain the CPU usage and I/O usage for a query prior to
execution. The output from Visual Explain gives me exactly what I
want,...
Wendy
|
11-14-2011 11:38 AM
Wendy | 2 | 3 |
| | | I am seeking the client setup for DB2 on Windows 95
Is there somebody who knows where i can find these
Marten
mar.houweninge@wxs.nl
|
11-08-2011 03:36 PM
TheBoss | 2 | 3 |
| | | I am trying to get the admin_move_table command to work to move a
table from one tablespace to another. Got it to work on a simple dummy
table, but...
esmith2112
|
11-07-2011 08:46 PM
Naresh Chainani | 4 | 5 |
