Rating Thread / Thread Starter	Last Post	Replies	Views
Using Transactions to Insert Data to Db2 Database Hi All I am trying to insert data within a transaction, into a Db2 database from asp.net. I have created a System DSN using ISeries Access... Dinu	08-24-2004 11:41 AM Dinu	0	89
slow connections with DB2DataSource Its taking ages (600msec) to get connections. I am running my application outside of a J2EE container environment using DB2 UDB 7. It all works, its... John	08-24-2004 11:22 AM John	0	90
Identity column Equivalent for DB2? Hi, Is there an Equivalent in DB2 like an Identity Column in SQL Server? Does it behave the same way (if ever it exists?). Thanks, JWK Johnnywhizkid	08-24-2004 10:15 AM RdR	2	61
application status question On DB2 ESE v8, AIX 5.2 Would it be correct for an application snapshot (global) to show a status of UOW Waiting when it hasn't returned results but... Rita Childress	08-23-2004 08:45 PM Rita Childress	2	94
FYI: Official Stinger announcement ( 1 2 ) You can read the full announcement letter at http://tinyurl.com/3tkr9 Gert van der Kooij	08-23-2004 03:57 PM Serge Rielau	15	131
Need Updated List of DB2 CLI PATCH2 Keyword Values Does anyone no where I can get the latest, up-to-date list of valid values for the CLI PATCH2 keyword? I followed the current link in the on-line... Perry Shindle	08-23-2004 03:03 PM Perry Shindle	0	75
Huge estimated cost for a simple delete statement with cascade Hi, I have a table (TAB1) withi has 4 child tables on COL1 with DELETE CASCADE. When I delete any row in TAB1, it will delete corresponding rows... Kumar	08-23-2004 02:15 PM Kumar	3	76
Direct Access Without Index ? This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as... WalterR	08-23-2004 01:30 PM robert	9	84
Not more than 5 Threads Hi @ll! OS RedHat 9.0 DB2 8.1 unixODBC 2.2.9 I have a problem with the connection over unixODBC i cant open more than five threads then it will... indika	08-23-2004 07:16 AM indika	0	77
SQL Server inked server to as400 - for the love of god please help. From a guy in Microsoft newsgroups: So here's my transplanted post ========================================== i'm trying to setup a linked server... Amanda	08-23-2004 01:07 AM Mark Yudkin	2	182
db2diag.log not writing We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and no new line written into it for few days. The last lines in db2diag.log... Shawn	08-22-2004 10:06 AM Ian	7	71
DB2 V8 FP7 problem Hi, I'm running DB2 PE on Windows XP Home edition. I downloaded FP7 (DB2 8.2) from the IBM ftp site and try to create a database. It fails when... Gert van der Kooij	08-21-2004 09:53 AM Ian	2	87
DB2 UDB Error Message We have a WebSphere application that quit working this week. It was trying to hit DB2 UDB Version 8 on Linux. The Driver is DB2 V7. This is the... afreema@cio.sc.gov	08-21-2004 09:30 AM Ian	2	155
DB2 v8 performance improvement for Stored Proc resolution Hi all I while ago I posted a suggestion to the DB2... Peter Arrenbrecht	08-20-2004 02:25 PM Serge Rielau	3	74
load with "allow read access" gives -911 on UDB v8 FP 5 on AIX When running LOAD with "ALLOW READ ACCESS", I get the following error if select is running againt the table (isolation UR). load.sql --------- db2... Prince Kumar	08-20-2004 12:17 PM Prince Kumar	3	94
DB2 ContentManager Windows Programming App. Search Method Hi, I try to perform a search with the search method of the application object: "Set FolderObj = VhlApplObj.Search(ItemTypeName, Criteria,... Thomas Sturm	08-20-2004 04:59 AM Thomas Sturm	0	74
Intermittant user authentication error Helpful folks, We have been having an intermittent and completely unreproducable problem concerning user authentication on Windows 2000: SQL1403N ... Sean C.	08-20-2004 02:34 AM Mark Yudkin	1	70
Check temporary table existing Hello DB2/NT 8.1.6 In procedure (SQL) I declare GLOBAL TEMPORARY TABLE. Sometimes this procedure is called twice a session and error creating table... Yaro	08-19-2004 09:16 PM Philip Sherman	1	84
Snapshot function? Hello all ... hopefully without sounding too obtuse, we've run into a case where we need to persist the contents of a view for performance reasons. ... Mairhtin O'Feannag	08-19-2004 05:49 PM Serge Rielau	4	89
Catalog Cache vs. Buffer Pool for SYSCATSPACE I understand the concept of catalog cache (memory allocated from the dbheap to allow catalog lookups without the need to access disk each time). But... Mark	08-19-2004 05:43 PM Serge Rielau	6	67
as400 and sql via ODBC Hello, I've a big problem, i need to adapt this sql string: SELECT ... FROM T4 WHERE (((IsNumeric(Trim(Mid(,5,2))))=True) AND ((T4.B)=1)); for... Peppe	08-19-2004 12:59 PM Peppe	0	80
Java Stored procedures 8.1.6 I tried to compile Java stored procedures and I am getting this message .. SQL1131N DARI (Stored Procedure) process has been terminated abnormally.... Uma	08-19-2004 12:03 PM Rhino	1	62
DB2 V7 z/OS and ODBC CLI optimization Hi I'm using DB2 UDB Runtime Client V8 (fixpak 6) through a DB2 Connect EE V8, to get data from DB2 V7 at z/OS. Previously I used SYSSCHEMA to... Kim Bundgaard	08-19-2004 09:46 AM Kim Bundgaard	0	77
Re: DBA command Eugene wrote: I was going to suggest sudo, but I am surprised that your IT organization sees sudo as a security risk! sudo can control exactly... ChetWest	08-19-2004 09:12 AM Ian	1	84
Search Criteria for Windows Programming Hi, I try to perform a search with the search method of the application object: "Set FolderObj = VhlApplObj.Search(ItemTypeName, Criteria,... Thomas Sturm	08-19-2004 07:45 AM Thomas Sturm	0	72
db2 function error! help my function is CREATE FUNCTION BOD_SEQ_NEXT () RETURNS NUMERIC(19) LANGUAGE SQL MODIFIES SQL DATA FENCED NOT DETERMINISTIC shibing.yu	08-19-2004 06:27 AM Serge Rielau	3	81
Proc1 result set with proc2 Hello DB2/NT 8.1.6 Stored procedure Proc1 (SQL) return result set. How can I call Proc1 in Proc2(SQL) and scroll on Proc1 result set?... Yaro	08-19-2004 04:28 AM Yaro	2	66
DB2 8.01 - need help with deadlock problem (Event Monitor Log Attached) Hello all, we are running a delphi application with DB2 V8.01 which is causing deadlocks when rows are being inserted into a table. Attaching... Rohit Raghuwanshi	08-19-2004 03:11 AM Rohit Raghuwanshi	1	97
Deletes way slower on AIX, two questions Folks I run a process on both the windows and aix process. The process consists of many steps most are about the same on both platforms. However... Bob Sparks	08-18-2004 05:03 PM Mark	2	70
query timeout Hi all, I'm writing an ODBC application on NT Server, accessing a db2 udb v 8.1.6 database on AIX. I'd like to issue a query, and if... Abram Friesen	08-18-2004 04:43 PM Abram Friesen	0	104
DB2 READLIMIT parameter : where is it documented ? Hi, I would like to get information about the db2 paramater READLIMIT, that was introduced in V7R1. I cannot find the location of a IBM manula... sbxjld	08-18-2004 10:09 AM Rhino	1	70
list database partition...... Hi All , I have a UDB 8.1 to look after, when i check on the DB partition groups, it shows me only 2 groups ( as shown below) & misses IBMTEMPGROUP... Deepak Rao G	08-18-2004 09:14 AM Deepak Rao G	0	64
Issues with Index, Full Scans instead ( 1 2 ) I have the following sintax: Select * From Inventory Where PartId = Coalesce(v_PartId, PartId) this type of query is used within an store procedure... LUIS FAJARDO	08-17-2004 08:12 PM LUIS FAJARDO	13	133
EEE partitions process performance are different Hi All, I have DB2 EEE 7.2 12 db partitions running on AIX 5.1ML5 P690( one server). The AIX workload manager is on. I started the same... Jack Li	08-17-2004 01:30 PM Jack Li	6	70
Perl and DB2 Stored Procedures Folks, I am calling a DB2 stored procedure through Perl using the DBI:ODBC module. I am not sure if I can do this or not because I have been able to... Samarth	08-17-2004 01:28 PM Samarth	3	70
Catalog Cache vs. Buffer Pool for SYSCATSPACE I understand the concept of catalog cache (memory allocated from the dbheap to allow catalog lookups without the need to access disk each time). But... Mark	08-17-2004 11:19 AM Mark	0	69
order by issue i have the table create with append on option (append on the data to the end of last page), so suppose the data order is by arrival sequence. but... db2group88@yahoo.com	08-17-2004 01:47 AM Knut Stolze	2	114
SQL0407N occurs when binding files from older version (DB2 v7.2 @ OS/2) Hi, when binding V2 or V6 bind files to a V7 database, we get a SQL0407N on a system table (SYSIBM.SYSPLANDEP). The Database versions are: - V7.2,... helmut	08-16-2004 11:12 PM Jan M. Nelken	3	86
Insert is slow are there tweaks? Hello I am running an insert that takes an awfully long time compared to the same workload on Oracle. It takes 44 minutes to insert 2.5 million... Bob Sparks	08-16-2004 05:29 PM Serge Rielau	4	79
DB2 v8 32 bit on Solaris 64 bit ( 1 2 ) I've been asked to administer a DB2 V 8 (32-bit install) on a Solaris 64-bit platform. It seems like whomever installed DB2 on the server, goofed... Amy DBA	08-16-2004 07:44 AM Simon Tobias	13	119
Bind Error while using ALIAS on VIEW with other owner (DB2 OS/390) We have following situation: USER1 uses secondary-IDs SEC1 and SEC2 We defined an ALIAS with SEC1.ALIAS1 => SEC2.VIEW1 => SEC2.TABLE1 and GRANT... Max Hotte	08-16-2004 06:56 AM Max Hotte	0	73
SQL0444 received when executing a stored procedure I have v8.1 fix 5 installed on windows 2k. I compiled a stored procedure in development environment, then used the get routine command to generate... JS	08-16-2004 03:47 AM Knut Stolze	5	84
Re: SET QUERY OPTIMIZATION in UDF "Eugene" <eugene (AT) profitlogic (DOT) com> wrote running. Assuming you are talking about DB2 V8.1 on Windows/Unix/Linux, the answer can be found... Rhino	08-16-2004 03:37 AM Knut Stolze	1	76
problem using java packages in jdbc stored procedures hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java... Kent Lewandowski	08-16-2004 03:35 AM Kent Lewandowski	2	102
Solaris kernel parm sd_max_throttle With Symmetrix, what are some of you seeing sd_max_throttle set to . A shop has it set to 20, which I believe is an EMC recommendation. Is this ok? ... John	08-15-2004 10:48 PM PM \(pm3iinc-nospam\) CGO	1	112
Prefetchers OK, there are lots of recommendations out there for number of prefetchers to configure. But, there isn't any guidance on how to tell if I have too... John	08-15-2004 10:33 PM PM \(pm3iinc-nospam\) CGO	2	119
Statement event monitor doesnt report statement text I have v8.1 fix5 using Win2k AS on 7 node logical system. I create event monitor writing to file and turn it on. Using application, I connect to db... JS	08-15-2004 03:50 PM JS	2	61
DB2 UDB 8.1 Exam 700 Hi DB2 users Anybody knows Where I can found braindumps of DB2 exams (FREE) ? Thanks PID XxX	08-14-2004 09:30 PM Mark A	1	96
Runstats manipulation My situation is as follows. I have several big SQL queries in a data warehouse using 1 big fact tables and 10 dimension tables. The queries join all... Jan Arickx	08-14-2004 05:59 PM Amy DBA	3	74
backup/restore nTs data hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be... Hardy	08-13-2004 07:43 PM Fan Ruo Xin	4	81

Page 178 of 238

178

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off