DB2
in [SQL]
|
Message queue sizing on Linux Hello, Situation: New x86-64 Red Hat Enterprise Linux 5.4 (64 bit) server with plenty of RAM (192GB) and DB2 ESE v. 9.7 FP1. The server has one DB2 instance, hosting one 10TB database. I had tried adjusting some kernel limits according to http:// publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/ com.ibm.... 17 Mar 2010 13:35
SQL0101N for a Select query Hi, I get this error SQL0101N error for the Select Query. I know that I am selecting all the colums from 10 tables and passing like 200 values to the IN Clause for a column. But it does work in other environments(different db2 versions though) but doesnt work in one environment. I am on db2 v9.5 fix pack 0. I tried... 25 Feb 2010 18:12
Limiting file system caching on RH Linux version 5 For DB2 Version 9.5, does setting swappiness= 0 (/proc/sys/vm/swappiness) on RHEL 5 sufficiently limit Linux file system caching, or is there some other way to limit on the percent of memory that can be used for Linux file system caching. Please do not explain to me how DB2 tablespace file system caching (or n... 23 Feb 2010 18:11
DB2 migration issue from v8.2 to v9.5 fp3 Hi, I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except the following issue from db2diag.log. ____________________________________________________ 2010-02-22-09.48.21.993163-300 I11339579A449 LEVEL: Severe PID : 28133 TID : 534 PROC : db2sysc 0 INSTANCE: db2... 22 Feb 2010 16:23
Register Free: IBM event on Cloud Computing on Feb 23rd in Delhi With Cloud Computing as an emerging style of Information Technology infrastructure designed for rapid delivery of computing resources. Now more than ever, you need to know why Cloud matters to maintain business growth, streamline operations and deliver unique business value. Listen to what experts have to say, and ... 20 Feb 2010 04:45
federation server developer edition and asynchronous processing Hi, I am working with WebSphere Federation Server v9.5. for LUW Developer Edition. What are the limitations of the developer edition? I was not able to find a list with the limitations. Specifically, are there any limitations in using asynchronous optimization and processing? Regards, Ruslan ... 18 Feb 2010 10:32
AUTHENTICATION=DATA_ENCRYPT Hi, I would like to use AUTHENTICATION=DATA_ENCRYPT parameter on my database for increased security. But I cannot find any in depth articles about it on the internet. I would like to know about the following: 1. If the data (SQL) is encrypted, will dynamic SQL snaphots show the SQL or does it show it in an... 22 Feb 2010 15:15
Alternative to COUNT(*) I am running DB2 V9.5 on AIX. We have a fairly small database (2 million records max on main table). We use COUNT(*) periodically. We also schedule runstats and online reorg periodically. At times COUNT(*) can be very slow and although a reorg/runstats speeds it up we can have a window when the count is needed ... 18 Feb 2010 17:20
using composite keys in an IN clause Hello, using DB2 version 9.7 I assumed the following would work. In this example, tableA has a composite key on x,y. select * from tableA where (x, y) IN ( ( 'x1', y1) ) but, DB2 throws this: SQL0104N An unexpected token "," was found following ", y) in ( ('x1'". Expected tokens may include: "+". SQLST... 15 Feb 2010 12:02
love with learning and earning of the people I made a web. For those people who want learn and earn by internet .please visit the link. http://affiliate.testking.com/adhit.php?i=0&c=MzE3M3xFNTMx&ad_channel=1118 ... 13 Feb 2010 06:01 |