| Thread | Last Post | Replies |
|
| Two different versions on DB2 on Window box? | 06 Oct 2004 20:07 GMT | 1 |
Can DB2 version 7.x and 8.x co-exist on Windows 2003 server? I saw the messages in the newsgroup stated that two versions can run at the same time on an AIX box but I couldn't find any references to Windows-based servers.
|
| How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file? | 06 Oct 2004 19:11 GMT | 3 |
What I want to do is take that output, use the data within it to put into a shell script as input to another installation of DB2 Connect on another AIX box. Any ideas about how to do this?
|
| two phase commit? | 06 Oct 2004 17:03 GMT | 4 |
I need to do a two phase commit (a transaction over a table and a nickname). Trying to do so gives me the error SQL30090N reason = 18 The suggested action is: If multiple data sources need to be updated within a unit of
|
| simulating ldap with db2? | 06 Oct 2004 04:45 GMT | 3 |
I'm pretty sure I've seen an article on how to simulate an ldap server using db2, (developerworks?). However, I cant seem to find it anymore. Does anyone recognice the article I'm looking for, and where I can find it?
|
| DB2 Connection Pooling | 06 Oct 2004 03:07 GMT | 1 |
I know that DB2 LUW version 8 has "connection pooling" that provides a connection concentrator (limits the number of simultaneous connections that can occur). But does it really provide connection reuse in the same manner provided by DB2 Connect or Websphere (or some 3rd party
|
| collect sub-element statistics | 06 Oct 2004 02:46 GMT | 3 |
I ran the runstats and try to collect sub-element statistics, but for some reason, the value of that two fields in syscat.columns is always -1. Does anyone have any idea?
|
| Problems installing DB2 Contol Center. | 05 Oct 2004 23:49 GMT | 3 |
I am trying to install connect v8.1 on a windows xp PC to monitor databases on a AIX server. I tried unistalling and re-installing the Connect software and I now get the following error message when trying to re-install the connect software on the windows machine.
|
| container recovery | 05 Oct 2004 20:52 GMT | 3 |
Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards
|
| development center build fails | 05 Oct 2004 19:18 GMT | 2 |
I have DB2 8.1 FP7, when I try to build a Java stored procedure it fails during a call to DB2_REPLACE_JAR. Even the build folder "bld1096553970703" is not there - it has a different name, regards,
|
| Finding locks | 05 Oct 2004 18:31 GMT | 1 |
Ok, why does the db2 diag log not reporting deadlocks and escalations any longer? Something I am doing wrong here? Also in the db2diag.log what is the difference between and TID and a PID. If I try and trace the application id of process that locked I do not find it. My guess
|
| db2 - indexes | 05 Oct 2004 18:25 GMT | 1 |
J have tablespace named TSPACE, with table DATA with about 3mln rows. I want to create index named O123TA, but execution ends with error: DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70014, TYPE OF RESOURCE 00000220,
|
| newbie syntax error on trigger | 05 Oct 2004 16:05 GMT | 2 |
I have the following text in a text file that I run using the command "db2batch -d sample -f trigger.txt ....I can't get passed syntax errors ... the output follows the trigger txt. --#SET DELIMITER !
|
| Re: Buffer Pool size problem. | 05 Oct 2004 15:03 GMT | 2 |
AIX 4. DB2 7.2 I try to increase the buffer pool with the ID 1 using the following SQL to find out what size currently had: SELECT bpname
|
| Opening more than 1 table via the iDB2DataAdapter | 05 Oct 2004 13:51 GMT | 1 |
With the SQLDataAdapter it's possible to load more datatables via 1 fill command. ex: dim sqlstmt as string = "SELECT * FROM Customers; SELECT * FROM
|
| varchar vs char | 05 Oct 2004 00:18 GMT | 10 |
what's the difference of the two data types?
|