Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide

IBM DB2

Views: 6,906 Announcement: You cannot reply to these posts
June 20th, 2007 msquared (Admin)
Timestamps on data records, Documentation on old versions of DB2
2 Replies | Posted by: Ion Freeman | Last post by Karl Hanson, Today
Dave Hughes wrote: <snip> This is probably a long shot, but if the client tables are journaled (eg for commitment control), there may be a way to... more »
SQL0101N The statement is too long or too complex. SQLSTATE=54001
3 Replies | Posted by: Eric Davidson | Last post by Liam Finnie, Today
On Jul 2, 8:56 pm, "Dave Hughes" <d...@waveform.plus.comwrote: Hi Dave, This behaviour you notice is documented with the stmtheap... more »
DB2 8.2 Workgroup Server Edition limitattions
Post Reply? | Posted by: Mark A | Last post by Mark A, Yesterday
DB2 8.2 Workgroup Server Edition is supposed to be limited to servers with 4 CPU's and 16 GB of memory. It can be licensed by user, or by number... more »
privileges on functions
2 Replies | Posted by: uwcssa@gmail.com | Last post by --CELKO--, Yesterday
Does the function do something for which the user does not have privileges? more »
Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
1 Reply | Posted by: Frank Swarbrick | Last post by Marcin 'frodo2000' Molak, Yesterday
On 2 Lip, 18:07, "Frank Swarbrick" <Frank.Swarbr...@efirstbank.com> wrote: Hi, I have successfully put string with semicolon into table in DB2... more »
Re: Delphi + Stored Procedure + Locks
6 Replies | Posted by: Serge Rielau | Last post by Dave Hughes, Yesterday
John Hopfield wrote: Ah, you'll need to "start" the transaction with the StartTransaction method first. In the case of DB2 this is essentially a... more »
Find a sentence with words separated by multiple spaces
3 Replies | Posted by: bstjean | Last post by Lennart, Yesterday
On Jul 2, 9:49 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote: Damn, I hit the send button to soon. The output was produced before I fixed the... more »
library compatibility libdb2.so undefined reference to`__cxa_guard_acquire@CXXABI_1.2.1'
Post Reply? | Posted by: Justin | Last post by Justin, Yesterday
When creating an executible received this error during the linking... g++32 -L/usr/lib/x86_64-redhat-linux3E/lib64 -o confusion cdb.o conindb.o... more »
Temp tablespace - system or user?
3 Replies | Posted by: Arun Srinivasan | Last post by Arun Srinivasan, Yesterday
On Jul 2, 8:10 am, "stefan.albert" <stefan.alb...@spb.dewrote: Thanks both.. more »
Yellowfin Business Intelligence Release 4.0 Announced to Industry
Post Reply? | Posted by: Yellowfin | Last post by Yellowfin, 3 days ago
(CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst... more »
When does a stored procedure use an MQT
11 Replies | Posted by: peter | Last post by peter, 3 days ago
On Jul 2, 1:09 pm, Serge Rielau <srie...@ca.ibm.comwrote: Yep, but its basically the same object (content of bind file for LUW I think) just stored... more »
TRANSLATE function
4 Replies | Posted by: kovariadam@gmail.com | Last post by kovariadam@gmail.com, 3 days ago
Thanks, already solved. On 1. Júl, 22:20 h., Lennart <Erik.Lennart.Jons...@gmail.comwrote: more »
SMS TableSpace - Reorg not releasing space.
1 Reply | Posted by: Patrick Finnegan | Last post by Mark A, 4 days ago
"Patrick Finnegan" <finnegan.patrick@gmail.comwrote in message news:ea223638-743d-48f0-b590-b0f0b0413b4b@d1g2000hsg.googlegroups.com... You are... more »
Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings?
24 Replies | Posted by: machineghost | Last post by machineghost, 4 days ago
Just to clarify (for anyone else as clueless as me), the hexcode character entity stuff isn't actually necessary at all. In fact, the actual... more »
Multiple fault monitors from different db2 versions
Post Reply? | Posted by: 4.spam@mail.ru | Last post by 4.spam@mail.ru, 4 days ago
Hello. I have db2 v9.1 and v9.5 on the same machine (RHEL5). Can I run 2 fault monitor services from both these... more »
Export utility is taking long time
1 Reply | Posted by: kavin | Last post by Serge Rielau, 5 days ago
kavin wrote: Could it be that you have I/O contention? I would check that first. Then I would check lock contention. A lakh is not a measure... more »
Export utility is taking long time
Post Reply? | Posted by: kavin | Last post by kavin, 5 days ago
our Customer used to take backup all the tables of a particular schema using export utility, previously the export operation used to finish within 30... more »
Export utility on a table is taking long time
Post Reply? | Posted by: kavin | Last post by kavin, 5 days ago
our Customer used to take export backup of a particular schema, previously it used to finish within 30 Minutes. As of now it is taking almost 12... more »
Runstats error
Post Reply? | Posted by: rajdb2 | Last post by rajdb2, 5 days ago
I am getting the following error for runstats for a few large tables in my prod database. I have increased the stats heap size to 6500 from 4382,but... more »
Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
7 Replies | Posted by: Okonita via DBMonster.com | Last post by Okonita via DBMonster.com, 5 days ago
Got it and thank you. peter wrote: > -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200806/1 more »
How to reduce the highwatermark for a DMS tablespace?
4 Replies | Posted by: rajdb2 | Last post by rajdb2, 5 days ago
On May 5, 1:48 pm, "The Boss" <use...@No.Spam.Please.invalidwrote: Thanks Lennart,Jeroen and AJ more »
Re: Community's water tower perhaps somewhat in questionable taste
Post Reply? | Posted by: Atrophier Bigarrés | Last post by Atrophier Bigarrés, 6 days ago
Vuona 2007 ilmoitettiin, että sähkön kulutus oli kääntynyt pysyväismuutosta ennakoivaan laskunsa. Vaikka ydinala vedätteli vielä eetteriin peräti... more »
the option CPU_PARALLELISM of LOAD
2 Replies | Posted by: chunguang yuan | Last post by chunguang yuan, 6 days ago
On 6ÔÂ27ÈÕ, ÏÂÎç3ʱ39·Ö, peter <peter.p...@gmail.comwrote: thanks!:) more »
BACKUP & RUNSTATS running simultaneously
1 Reply | Posted by: satish mullapudi | Last post by peter, 7 days ago
On Jun 18, 3:51 pm, satish mullapudi <satishmullapud...@gmail.com> wrote: Hi We have had this problem and if you read the manual it is... more »
Urgent - need help
1 Reply | Posted by: contactrajib@yahoo.com | Last post by peter, 7 days ago
On Jun 28, 1:31 am, contactra...@yahoo.com wrote: If there is unique index access, no lock escalation, no next key issues and appropriate commits... more »

  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors