Typically, what DB2 components (clinet) have the essential DBA tool
(control center)?
I have Apple PowerMac dual CPUs, does IBM have plan to support DB2 on
Mac OSX?

I'm running DB2 v7 for z/OS. When I use SPUFI, SELECT CAST(6.0 AS
FLOAT)/CAST(10.0 AS FLOAT) FROM SYSIBM.SYSDUMMY1 returns
0.6000000000000000E+00. When I use DSNTIAUL,DSNTEP2, or DSNALI (call
attach facility), the same statement returns 0.59999999999999999E 00.

I am new to mainframes and am doing some research to look for security
solutions for our mainframe environment. I appreciate any responses
that will help me out.
I have a few questions, primarily around pricing for mainframe

I keep recieving this error while installing express c db2 on debian.
ERROR:SQL1220N
ERROR:SQL1220N  The database manager shared memory set cannot be
allocated.

64 bit instance:
DB21085I  Instance uses "64" bits and DB2 code release "SQL08027" with
level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and

I was looking at SQL limits at
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.admin.doc/doc/r0001029.htm
but I cannot find an information about the maximum size of a large SMS table
space. Where can I get it or what the size is?

     I am working on a database that has a variable with timestamp
values. I wanted to convert the variable from timestamp to yyyy-mm-dd
format.
Thanks in advance

I'm tracing cli calls from a windows machine running client 8.1.11.  I
get the sql statement with the parameter markers but don't get the
values assigned to each variable.  Here is what I get:
[0000002032 0000002348] [02/07/2008 16:48:52.291153] ( hStmt=1:1,

I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection.  An attempt was made to access a

I had the following doubts about the "For Read Only" clause.
1. How does a "for Read only" clause improve the performance?
2. How does a "for Read only" clause compare with "With UR" clause in
performance? Which is faster?

A table was originally designed to temporarily hold  data (loaded
using the load utility) until a sp ran to insert/update the target
prod tables. The load utility was used with a replace option, so the
table was basically refreshed each time it ran for a new contract. No

I am restoring a database (approximately 1 Terabyte).  After the
restore started, I noticed that the "list utilities" completed work
was not being updated.  I checked the location of the restore and
watch to see that the size of the table spaces was increasing.

I have the following doubt.
Suppose I use the execute immediate statement and the statement to be
executed is a Select statement from the sysibm.sysdummy1 table which
will always return me one row.

I've been trying to tune this complex sql that uses the 'exists'
clause. It is damn slow, even though the tables are not big and I have
indexes on the columns in the sql. Currently I am trying MQTs, but
when I was tuning them, I was changing the reopt parameter in the

I have 2 databases with the same layout (but slightly different data)
on 2 different servers.  I have a query I'm trying to run which
performs poorly on one of the servers due to sort issues, but performs
fine on the other server.  Here's a portion of the query plan I'm