DB2
in [SQL]
|
CLOB and searching by it Hello all, I have table with CLOB column length of ~65K. application is searching from this table by CLOB and i can not create index on it. I know IBM recommends using DB2 Net Search Extender or DB2 UDB Text Information Extender for searching CLOBS but what are the other solutions out there. can i use some othe... 25 Jun 2008 16:02
Reorgchk, Reorg, Runstats not having any effect after completion. Why is this? Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be identified and selected as reorg candidates in subsequent/followup reorgchk. Has anyone had this experience? Can you share wit... 29 Jun 2008 17:16
SQL to find if table has identity and/or row change timestampcolumns Frank Swarbrick wrote: On 6/22/2008 at 6:58 PM, in message <6c8apkF28va8mU1(a)mid.individual.net>, Serge Rielau<srielau(a)ca.ibm.com> wrote: Frank Swarbrick wrote: How can I fix this so that it doesn't do essentially the same scan twice, but it gives the same results (a single row where IDE... 23 Jun 2008 11:41
SQL to find if table has identity and/or row changetimestampcolumns >>> On 6/22/2008 at 6:58 PM, in message <6c8apkF28va8mU1(a)mid.individual.net>, Serge Rielau<srielau(a)ca.ibm.com> wrote: Frank Swarbrick wrote: How can I fix this so that it doesn't do essentially the same scan twice, but it gives the same results (a single row where IDENTITY_MODIFIER is either 'identit... 23 Jun 2008 11:41
SQL to find if table has identity and/or row change timestampcolumns Frank Swarbrick wrote: How can I fix this so that it doesn't do essentially the same scan twice, but it gives the same results (a single row where IDENTITY_MODIFIER is either 'identityoverride' or '' and ROWCHANGETIMESTAMP_MODIFIER is either 'rowchangetimestampoverride' or ''? select case ... 22 Jun 2008 21:24
SQL to find if table has identity and/or row change timestamp columns How can I fix this so that it doesn't do essentially the same scan twice, but it gives the same results (a single row where IDENTITY_MODIFIER is either 'identityoverride' or '' and ROWCHANGETIMESTAMP_MODIFIER is either 'rowchangetimestampoverride' or ''? select case when exists ( select * ... 22 Jun 2008 21:24
DB2 9 runtime client install Hi, I've been trying for 2 hours to install in silent mode a DB2 9 runtime client. Why didn't you make this process as simple as for the CLIENT install ? It is not the same setup command, you can download a setup from the support site, but unfortunately, the setup does not allow you to create a response fi... 23 Jun 2008 16:51
Estimating performance on an OLAP database (virtualization vs. server install) Hi all, We're trying to test DB2's performance for an OLAP data warehouse. We went with a column-store based approach after loading using a row- store approach generated over 2 million rows for just a single month's worth of data. We're using Alphablox as the cubing engine, but we have found that queries ta... 22 Jun 2008 14:15
How can I use shell script to remove specific records from a flat file? Hi all, Working on a little shell script to remove specific records from a flat file. I have scanned a one or two script books and googled for answers but have no success. Can someone show me how I can do this. For example, how can I remove the something like the following records from among 200 other records: DB2... 22 Jun 2008 18:20
import XML file into DB2 table Hi all, I have 6 tables inside a MS Access 2003 mdb file. I want to convert them as DB2 version -8 tables in AIX 5.2. I have exported them as 6 XML files. The XML files look fine. Each record is embeded by a tag which is the table name. Then, each column is embeded by a tag which is the column name. Even... 24 Jun 2008 22:36 |