DB2
in [SQL]
|
TRANSLATE function Hi, Does anybody know why i get this error: SQL0176N The second, third or fourth argument of the TRANSLATE scalar function is incorrect. SQLSTATE=42815 with this query: SELECT TRANSLATE(p.meno, 'aaaaccdeeeiillnnoooorrsstuuuuyzzAAAACCDEEEIILLNNOOOORRSSTUUUUYZZ', 'áâãäæèïéìëíîåµñòóôöõàø¶¹»úüûùý¼¾ÁÂÃÄÆÈÏÉÌËÍÎÅ¥... 1 Jul 2008 17:29
SMS TableSpace - Reorg not releasing space. Running DB2 9.1 on Redhat Linux 4.1. Storage management indicates that the pages stored in a file based SMS container occupy 7 gig of the total space allocated which is 50gig. I wrote a script to reorg and runstat all the tables in the tablespace but the reorgs are not releasing space to the file system. Is t... 1 Jul 2008 00:02
Multiple fault monitors from different db2 versions Hello. I have db2 v9.1 and v9.5 on the same machine (RHEL5). Can I run 2 fault monitor services from both these versions simultaneously? Sincerely, Mark B. ... 30 Jun 2008 10:39
Delphi + Stored Procedure + Locks John Hopfield wrote: Maybe the transaction is already active? The CALL of my Stored Procedure should terminate with a COMMIT? (i never put "COMMIT" at end of my Stored Procedure) If you were Pinocchio I'd say: "Listen to the grasshopper". Locks have be held until the transaction commits. Ideally your applic... 4 Jul 2008 11:01
Export utility is taking long time 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 Minutes. As of now it is taking almost 12 Hours. mainly while taking the backup of three particular tables.This tables contains row sizes of 15 lakhs,one lakhs, 7... 30 Jun 2008 03:29
Export utility is taking long time 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 Minutes. As of now it is taking almost 12 Hours. mainly while taking the backup of three particular tables.This tables contains row sizes of 15 lakhs,one lakhs, 7... 30 Jun 2008 08:36
Export utility on a table is taking long time 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 Hours. Export is consuming more time while taking the backup of three particular tables.This tables contains row sizes of 15 lakhs,one lakhs, 75 lakhs respectively ... 30 Jun 2008 03:29
Runstats error 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 it didnot resolve the issue.Any help is appreciated. SQL2310N The utility could not generate statistics. Error "-930" was returned. ... 29 Jun 2008 17:16
How to reduce the highwatermark for a DMS tablespace? On May 5, 1:48 pm, "The Boss" <use...(a)No.Spam.Please.invalid> wrote: rajdb2 wrote: How to reduce the highwatermark for a DMS tablespace in V8.2? I have tried doing classic reorg on the table in the tablespace twice, but the highwatermark is lowered. Any ideas? Lennart already showed you a pointe... 29 Jun 2008 17:16
Community's water tower perhaps somewhat in questionable taste Vuona 2007 ilmoitettiin, ett� s�hk�n kulutus oli k��ntynyt pysyv�ismuutosta ennakoivaan laskunsa. Vaikka ydinala ved�tteli viel� eetteriin per�ti liki +10% kasvuhaaveitaan oli totuus karu, mutta selke� -1%. T�m�n vuoden alussa T&T ilmoitteli sitten jo yh� SELKE�MMIN kiihtyv�� s�hk�ntarpeen laskua. Ja ydinalamme ved... 29 Jun 2008 05:00 |