DB2
in [SQL]
|
Unicode database Hi all, I've a UNIX box which has a DB2 client (UDB v9.5) connecting to a remote DB2 server(UDB v9.5) and some SAS applications running on top of the DB2 client. The remote DB2 server is planning to convert from non-unicode to unicode. I'm wondering what's the impacts on my client side? Thanks in advance! ... 23 Jul 2010 19:06
db2 activate database results in 1226 - Overflow agent is notallowed It seems that maxagents or something similar has been reached. To narrow down the problem, I would need the output of: db2 get dbm cfg db2 get db cfg for <dbname> db2 list applications Please run those commands as db2inst1 and post them here. On 23.07.10 4:56 , db2 comp wrote: Hi all, I'm currentl... 23 Jul 2010 05:55
db2 activate database results in 1226 - Overflow agent is not allowed Hi all, I'm currently facing a problem with a Db2 database. When I try to activate / connect to it, following error occurs : --------------------------------------------------------- "SQL1226N The maximum number of client connections are already started. SQLSTATE=57030" -------------------------------------... 23 Jul 2010 15:48
Q about DB2 Express-C and Admin Tools Greetings: I saw a news article about DB2 Express-C running on Ubuntu Linux. I have one question about the DB2 Express-C edition: Do the usual DB2 admin tools (which come with DB2 workgroup edition for example) work and come with DB2 Express-C edition that may be installed on another system - be it a Linux or Wind... 23 Jul 2010 20:12
How to find the uncommitted culprit!? DB2 V9.5 on AIX, We received an error on one of our machines that the DB2 active log filesystem was full. I am assuming it was due to some uncommitted transaction so I am trying to hunt down who it was. To do this I was trying to determine what active log file was hung out in order to get a time period of how ... 19 Jul 2010 21:16
when does a commit occurs within an SQL file ? I'm wondering, whether the "nobody ...." comment in the following sql file (which is called via "$>db2 -t -f sql") : $>cat sql -- BEGIN delete from NEW ; -- nobody should to read from NEW at this point insert into NEW (select * from OLD) ; --EN... 21 Jul 2010 00:30
MDC on date column? Would it be a good idea to re-create this table with a MDC on the date column? The table has about 67M rows, not too wide. It keeps 250 days of data. There are around 270K rows on each day, variations are small. On every day, the oldest date is purged and a new date is added. Is it a good idea if I add a... 15 Jul 2010 08:44
FK's on Federated Databases My reading of the doc is that when using DB2 Federation (with nicknames, wrappers, etc), a foreign key can be created to accross two federated databases (parent and child on different databases), but that the constraint must be defined as NOT ENFORCED. Is that correct? ... 14 Jul 2010 19:49
Arrays vs Declared Global Temp Tables for Stored Procs in DB29.5 On 7/14/2010 12:45 AM, Martin wrote: I am using DB2 9.5.5 and cannot migrate to 9.7 anytime soon, so I cannot use Created Global Temporary Tables (CGTT). I am wondering how Arrays are implemented for stored procedures and what the performance is compared to declared global temporary tables (DGTT). In ord... 14 Jul 2010 13:10 |