DB2

Single column indexes supporting Foreign keys
I'm working on tuning a very expensive delete (cascades to hundreds of tables). I do not have the ability to change the RI within the database - that structure is vendor supplied(WebSphere Commerce). Running the index advisor on this delete comes up with 800 recommended indexes. I'm not willing to create all 800. S... 23 Mar 2010 11:16

Spatial Analysis: eSite chooses Yellowfin
eSite, Inc. has announced Yellowfin as the successful web based Business Intelligence vendor to provide them with integrated Location Intelligence. Yellowfin will be integrated into eSite Tools, a customized software toolkit to provide added reporting and analysis. As a full service location and market research f... 21 Mar 2010 09:22

paypal wholesale Puma (paypal payment)( www.jordanonline06.com)
paypal wholesale d&g shoes (paypal payment) ( http://www.jordanonline06.com/) paypal wholesale gucci shoes (paypal payment) ( http://www.jordanonline06.com/) paypal wholesale lv shoes (paypal payment) ( http://www.jordanonline06.com/) paypal wholesale NBA shoes (paypal payment) ( http://www.jordanonline06.com/ )... 20 Mar 2010 14:18

Discount VERSACE True leather AAA Wholesale (www.supertradeonline06.com )
Discount VERSACE True leather AAA Wholesale (http:// www.supertradeonline06.com/ ) Discount VERSACE bags Wholesale (http://www.supertradeonline06.com/ ) Discount Chanel Purse Wholesale (http://www.supertradeonline06.com/ ) Discount CHANEL bags Wholesale (http://www.supertradeonline06.com/ ) Discount CHANEL True le... 20 Mar 2010 09:45

Discount wholesale Rolex Watch (www.jordanonline06.com) (paypal payment)
Discount wholesale Rolex Watch (http://www.jordanonline06.com/) (paypal payment) Discount wholesale Omega Watch Discount wholesale Ebel Watch (http://www.jordanonline06.com/) (paypal payment) Discount wholesale LV Watch Discount wholesale Bell&Ross Watch Discount wholesale Breit Ling Watch (http://www.jordanon... 19 Mar 2010 15:29

DB2 access with NON-LOGABLE userid
Hi There, A user owns a bunch tables and have grant previleges on the database, but this was turned into a non-logonable on TSO ( removed from TSO ). Does this user still have access to the database via other tools , such as Aqua Data Studio or similar? Thanks! Guto. ... 20 Mar 2010 05:09

Federated Database Using EXISTS Clause with Common Table Expressions
I have a query that is not executing as expected when running it through a federated database. I've narrowed down the part that causes it to fail and am wondering if anyone knows why it fails, if there's a better way to do it. I have 3 DB2 databases all on the same physical server (AIX 5.3 with DB2 9.5). One is ... 16 Mar 2010 22:05

Problem with to_date-function on AIX
Valid format strings are 'YYYY-MM-DD HH24:MI:SS' only, on DB2 for LUW 9.1 or earlier. The format string 'YYYYMMDDHH24MISS' is supported on DB2 for LUW 9.5 or later. ... 16 Mar 2010 10:12

Problem with to_date-function on AIX
Hi, I am facing a little bit of trouble when trying to run the following statement on some AIX-Instances (All DB2-Versions from 8.2 up to 9.5): db2 "select max(to_date(end_time,'YYYYMMDDHH24MISS')) from table(admin_list_hist()) as histlist" I am getting the following error: SQL0171N The data type, leng... 15 Mar 2010 18:07

how to sum a derived column
Hi, The following statement was intended to get total count from each section first and then get the total counts of all sections. The union part works and returns. But 'select sum(used)' does not. The error message can be found at the end of this message. Appreciate any help! Thanks. ------ used 47 7... 12 Mar 2010 23:57