Description:
Problem resolution with DB2 database products.
|
|
|
locking mechanism semantics
|
| |
Some observations, more out of curiosity than anything else:
[lelle@dustbite ~]$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release
"SQL10010"
with level identifier "0201010E".
Informational tokens are "DB2 v10.1.0.0", "s120403", "LINUXAMD64101",
and Fix
Pack "0".... more »
|
|
|
Restrict user IDs to specific servers
|
| |
We have group of server IDs, and group of user IDs. We are trying to find the best way to restrict the server IDs(generic - like db2adm) to connect to the database only from that server and not from any user client(ID mismanagement).
One idea is to construct workload and disable them (using User ID/application name combination - like db2admin/toad.exe)... more »
|
|
|
SQL Stored Procedure Issue with a DATE Variable
|
| |
Using DB2 Express-C 10.1.2 LUW on Win 7 Pro SP1 both 64-Bit, I have the below listed example portion of a SP.
The INSERT statement using the variable V_ACT_DATE that is input at the time of the call statement ie: CALL TEMP_PROC('05/07/2013');
The problem appears to some form of DATE conversion, as if I hard code the date by replacing V_ACT_DATE in the select statement with the actual date ie: '05/07/2013' all is fine. However if I use the variable name in it's place ie: V_ACT_DATE (as written in the code) then all hell breaks loose. The SP finishes successfully, but instead of taking 10 secs to run, it takes 7 minutes and hammers the hell out of my SSD in the TMPDB2ADMIN table space writing over 50gb of temp data to insert some 350k records.... more »
|
|
|
Platform mismatch message even though platforms seems to match
|
| |
Hi, we are trying to install this package
IBM DB2 Advanced Enterprise Server Edition V9.7 for Linux
on AMD64 and Intel EM64T systems (x64) English (CZVG5EN)
on a system for which the "uname -a" command returns this:
Linux farm0148 2.6.18-274.7.1.el5 #1 SMP Mon Oct 17 11:57:14 EDT 2011... more »
|
|
|
SQLfly New Generation Database Tool
|
| |
SQLfly is a database management, schema/system compare, database quality reports and database query tool to make every day work more productive. Currently supports ORACLE Databases (Oracle 9i, 10g, 11g). SQLFLY provides both Desktop and Mobile version of the products to access database anywhere, anytime!... more »
|
|
|
DB2 Express-C manager wanted
|
| |
Hi,
I am looking for somebody able to manage an IBM DB2 Express-C server in the cloud for me (I am a web developper) : installation, monitoring, management (patching and upgrading).
Anybody interested please contact me by e-mail.
|
|
|
grant control on table, to run runstats via sp, not working in V9.5.0.7
|
| |
Have a stored procedure that runs the following CALL SYSPROC.ADMIN_CMD ('RUNSTATS ON TABLE SDBXXX.TABLENAME with distribution and detailed indexes all')
Granting control to the user works.
When control is granted via the role this does not work.
SQL2311N The user does not have the authority to run the Run Statistics... more »
|
|
|
INCREASESIZE for AUTOMATIC STORAGE tablespaces
|
| |
Hi Team,
My env details
DB2 v9.5 , AIX 5x
As given in infocenter :
"If you do not specify the INCREASESIZE clause when you enable the auto-resize feature, the database manager determines an appropriate value to use, which might change over the life of the table space."
How to determine the INCREASESIZE that the dbm is going to increase for a tablespace, when the need comes !... more »
|
|
|
