how structure of the rid?

hello: in db2 v9,how structure of the rid? in db2 v9.7,how structure of the rid? in db2 v9,if the page is 32k,the limit of tablespace is 16T,why in db2 v9.7,is 64T? thank you!

DB2 V10 and z800

The DB2 v10 announcement letter has a conflicting statement '.DB2 10 for z/OS operates on z10T, z9T, z990, z890, or higher, processors supported by z/OS V1.10, or later. The first part of the statement says z800 and z900 will not run DB2 V10. The second part states any processors supported by z/OS v1.10 or later. Now z/OS 1.10, 1.11 and 1.12 will all run on z800 and z900. There was an early announcement of z/OS v1.10 (I think - could have been 1.11 or 1.12) that excluded z800 and z900 but this was quickly corrected after it came out. I'm a little confused.. will DB2 V10 not run on z80

strange query behaviour

Hi, I am experiencing problems running a query on a warehouse-server. DB2 8.1 FP 12 on AIX 64 bit (Upgrade to 9x cannot be done in the near future). Situation: One complex query with 2 different arguments: 1. where year='2008' (or 2006, 2007..) - runs fine everywhere 2. where year='2009' - runs locally on the DB2-Server and returns the expected results. - hangs on remote Windows-Client (32bit) "Hangs" means: The query never finishes. Same behaviour with command editor and commandline-client (so it can´t be a jdbc-issue). Application snapshot shows that the quer

Non-agent threads in db2

Was reading about workload manager in http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.wlm.doc/doc/c0051417.html "Setting the agent priority for a DB2 service class only adjusts the priority of agents running in that service class for new work that enters. 'Other non-agent threads' running in the service class do not use the agent priority value specified for the service class." Can anyone please brief on what those non-agent threads may be?I thought any sql or snapshot will use agents.

DB2 Express C - FP1

I thought Oracle compatibility was enabled in DB2 Express C 9.7.1. But when I did 'db2set db2_compatibility_vector=ORA' it errored out asking me to check the possible values. Is it that it isn' tenabled in Express-C yet?

Marriage visa

Marriage visa http://jobs-visa-immigration-consulta.blogspot.com/

341594 Information portals for computer and Web technology 23

I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia Produxction or anything that wil make me a penny, just student scraping by. But Guess what? I don't want your money, your e-mail, or anything. Each of these sites has a specific topic but they have them style and layout sothey are easy to navigate and ther a search function should take you to exactly where youwant to, o

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. So I'm trying to find those that would have the most impact. This is db2 version 8(supported through the commerce license), and I don't expect to upgrade in the near future. Linux OS. I have to run thousands of deletes per day. Yes, my runstats are up to date - I do those an

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.

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, length or value of argument "2" of routine "SYSIBM.TO_DATE" is incorrect. SQLSTATE=42815 The same statement on Linux returns the right value: db2 "select max(to_date(end_time,'YYYYMMDDHH24MISS')) from table(admin_list_hist()) as histlist" 1 --------------------------

Recommeded SHMALL Linux kernel parm for DB2 Linux 9.5

Here is the recommendation for SHMALL in the Redbook entitled Up and Running with DB2 on Linux (SG24-6899-01) that covers V9.5: "In this example, SHMALL is set to 8 GB (8388608 KB = 8 GB). If you have more physical memory than 8 GB for DB2, increase the value of this parameter to approximately 90% of your computer�s physical memory." Here is the recommendation from the current DB2 9.5 InfoCenter for SHMALL on Linux: IPC kernel parameter: kernel.shmall (SHMALL) Enforced minimum setting: no value is enforced Recommended minimum value: 2 * <size of RAM in bytes> (setting is in

Doing a join on a non-numeric column?

Greetings. I'm trying to execute a DB2 command such as: SELECT P.ITEM_NO, D.FILE_NAME FROM PRODDB2.PART P LEFT JOIN PRODDB2.DATA D ON P.OBJ_ID = D.OJB_ID but I get: "D.OJB_ID" is not valid in the context where it is used. SQLSTATE=42703 Ah, but OBJ_ID column is type CHAR(30). So I suppose I may need to match with "like" instead of "=" So I change the last part: ON P.OBJ_ID LIKE D.OJB_ID Alas, that doesn't help: An unexpected token "D" was found following "". Expected tok

Discover Location Intelligence

For traditional reporting, the dimensions of who, what, and when (customer, product, time), are well covered, however, the "Where" gets little attention. Location Intelligence, the mashup of Business Intelligence with GIS, brings visibility to the "where". Yellowfin's tech team have produced the following whitepaper to expose the process and benefits of Location Intelligence. Once you read it i'm sure you will be thinking about how LI can create powerful business insights from your data. Enjoy! Extract For decades, GIS was the only comprehensive option for managing loca

287202 Information portals for computer and Web technology 25

I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia Produxction or anything that wil make me a penny, just student scraping by. But Guess what? I don't want your money, your e-mail, or anything. Each of these sites has a specific topic but they have them style and layout sothey are easy to navigate and ther a search function should take you to exactly where youwant to, o

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 increasing the STMTHEAP upto 100000 from 40000 but still doesnt work. Is there anything else I can do.

Design Dashboards in Seconds by using IQ 2020!

Use IQ 20/20 to produce stunning Reports and Dashboards from your DB2 data as well as other data sources. If you have invested time and money into building your DB2 data then you probably realized that is only part of the equation. The next step is how do you present the data to your clients (internal or external) in a way that is easy to understand, compelling and facilitates action. Our IQ 20/20 solutions solve this problem. You can connect our IQ Designer to your DB2 data, or just about any other data source, and in minutes create stunning visuals (Reports & Dashboards). Aft

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: db2inst1 NODE : 000 DB : SYSCAT APPHDL : 0-19150 APPID: *LOCAL.db2inst1.100222144821 AUTHID : DB2INST1 EDUID : 534 EDUNAME: db2agent (SYSCAT) 0 FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization, probe:30

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

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 encrypted format? Or is there a setting that needs to be done? 2. If type 4 drivers are used by the clients and they do not catalog the databases on the clients, will they be automatically using DATA_ENCRYPT or will it default to SERVER. Also, when using DATA_ENCRYPT, doe

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: "+". SQLSTATE=42601 Is this not supported in DB2 or is my syntax wrong? Thanks.

Get tablespace autoresize config setting in DB2 V8 via table functions?

Hi, I'm writing scripts to monitor our databases. They should be somewhat universal, i.e. run on on DB2 versions 8+ (yes, we still have some V8 databases). Is there a way to get the autoresize flag of a tablespace using a table function (or any other SQL statement)? Of course, I could parse GET SNAPSHOT FOR TABLESPACES or db2pd, but I want to implement everything in SQL. Thanks in advance, Willem

Adding DB2 Connect license file to DB2 Express-C 9.7

Can i add the DB2 Connect Personal Edition V9.7 license file (from a commercially licensed copy) to a directory in my DB2 Express-C V9.7 installation to obtain connection to z/OS without actually installing DB2 Connect Personal Edition? I believe the license is a jar file.

Installing IBM Data Studio V2.2 and Websphere Community edition on windoze 7

Hi all, I'm trying to install the above 2 packages on windoze 7 (64 bit) VmWare image and for both of them I get an error message saying that the installer is unable to find an appropriate Virtual machine. I tried SUN JDK 1.6patch level 17 and the IBM JDK that comes with webspehere to no avail. running java --fullversion from the command line shows what appears to be a valid version of java installed. However, I've just installed both packages on a VmWare Vista 64 bit image with no problem Rgds Alex

Join pushdown to UNION ALL view

Hello, I'm trying to do a left outer join between simple table to a UNION ALL view of two base tables and I'm getting horrible performance due to a tablescan of the base tables of the view even though the join columns have indexes and great cardinality. My table config and sql are as follows: TableA id int, idb int (foreign key from TableB) TableB/TableB2 and ViewB = select * from TableB UNION ALL TableB2 id int select * from TableA as A left outer join ViewB as VB on VB.id=A.idb where A.id>? and A.id<? If I substitute one of the base tables (TableB or TableB2)

Deadlocks with only one side reported

I'm working on some deadlock analysis, and when I parse the output of the deadlock event monitor, I discover that for over half of my 26 deadlocks in an hour, the deadlock event monitor has only reported on one of the two applications involved in the deadlock. I've seen db2 report properly on 3 or 4 way deadlocks, so I don't think this is that. And the event monitor clearly lists that there is another application involved - but only shows details on one of them. Yes, I flushed the event monitor before generating the output. I'm db2 8.2 FixPack 18 on Linux (old, I know). Can anyone