dbTalk Databases Forums  

Sponsored Links


comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss in the comp.databases.ibm-db2 forum.



Post New Thread
Threads in Forum : comp.databases.ibm-db2 Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Is there a query from a snapshot table, or some other method, to monitor that a database is using trusted context connections? My company is...
Ultrak The DBA
Today 05:50 PM
The Boss Go to last post
3 4
Greetings. I'm trying to execute a DB2 command such as: SELECT P.ITEM_NO, D.FILE_NAME FROM PRODDB2.PART P LEFT JOIN ...
DavidFilmer
Today 05:14 PM
Mark A Go to last post
1 2
For traditional reporting, the dimensions of who, what, and when (customer, product, time), are well covered, however, the "Where" gets little...
JTP PR
Today 05:46 AM
JTP PR Go to last post
0 2
On my XP sp3 box, I tred to upgrade my DB2 Express C 9.5 to 9.71, but I received the error SQL5055C during the DB2EXTSEC phase. Now I can't open...
Franco Lombardo
Yesterday 12:09 PM
Franco Lombardo Go to last post
2 16
I installed DB2 9.5.1 a while back on Windows XP. After completing that installation, whenever I open Firefox, I get asked which profile I want...
Rhino
Yesterday 10:33 AM
Rhino Go to last post
2 12
I have a Primary Key Index that has 11 columns in it. 80 million row table. The index is 100% clustered and has nlevels = 4. We have an Update...
jafastinger
03-08-2010 03:41 PM
jafastinger Go to last post
3 5
Hello, Setup: 9.7.1 (64 bit) running on x86_64 Red Hat Enterprise Linux 5.4. Often, when I take look at the list of applications, I see a session...
Troels Arvin
03-06-2010 03:32 PM
Troels Arvin Go to last post
2 15
A while ago I discovered a transaction that had been active for a long time. The statement where against a infrequently accessed table, and caused no...
Lennart
03-06-2010 01:08 AM
Lennart Go to last post
2 21
Setup: - Server with data residing on an XIV storage system. The XIV storage system spreads data over all available disks with no knobs to...
Troels Arvin
03-05-2010 03:45 PM
Ian Go to last post
3 15
Anybody has a write-up on installation and usage of Ruby with DB2 9.5 ESE on AIX 5.3/6.1? TIA
Asphalt Blazer
03-05-2010 02:29 PM
Ian Go to last post
2 6
Hi, here i have given my requirement details please give me some idea.......... i have created a new user(user2) in db2 database.now In that...
karthic
03-05-2010 12:10 PM
Ian Go to last post
1 11
Hi all, what are the possible ways to convert a non partitioned index to a partitioned index in DB2 V9.7.1? According to the InfoCenter, the only...
Damir
03-05-2010 10:53 AM
Naresh Chainani Go to last post
3 5
Hello All, I have a query that returns the following results. We get multiple rows back, with all the same info except for the...
eliane
03-05-2010 08:19 AM
--CELKO-- Go to last post
2 16
Hello, DB2 v. 9.7.1. During certain special workloads (e.g. parallel REORGs/RUNSTATs), I've seen the server consuming 450MB/s with 25000IO/s (yes,...
Troels Arvin
03-05-2010 02:10 AM
Ian Go to last post
1 9
Hi all, the command: call SYSPROC.EVMON_FORMAT_UE_TO_TABLES ('LOCKING', NULL, NULL, NULL, NULL, NULL, NULL, -1, 'SELECT * FROM...
Damir
03-04-2010 08:40 AM
Damir Go to last post
0 9
Hi, I get different results when I try to find the fenced user id of the instance and I need some help determining the right one so that I...
Kiram
03-03-2010 06:42 PM
Kiram Go to last post
0 8
The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational...
JTP PR
03-03-2010 05:00 AM
JTP PR Go to last post
0 12
Consider a table and a query referring to only a subset of the columns in that table. How early in the query evaluation is the projection carried...
jbdhl
03-02-2010 05:17 PM
Ian Go to last post
4 25
Hi all. I'm looking for db2 9.5 express-c for LUW (linuxx86_64). The ibm site only lets me download 9.7, but I need 9.5 since I have a 9.5 instance...
Jurgen Haan
03-02-2010 05:53 AM
Jurgen Haan Go to last post
0 10
As I understand when you set the DB2_COMPABILITY_VECTOR registry variable it allows execution of PL/SQL in DB2, but this only affects databases...
oddbande
03-01-2010 09:04 AM
Serge Rielau Go to last post
1 20
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...
Mia
03-01-2010 08:42 AM
Mia Go to last post
0 12
Driving and Car Maintenance: Transportation accounts for 66% of U.S. oil use -mainly in the form of gasoline. Luckily, there are plenty of ways to...
..
02-28-2010 05:20 AM
.. Go to last post
0 14
Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.
..
02-28-2010 05:17 AM
.. Go to last post
0 11
Hello, Situation: New x86-64 Red Hat Enterprise Linux 5.4 (64 bit) server with plenty of RAM (192GB) and DB2 ESE v. 9.7 FP1. The server has one...
Troels Arvin
02-26-2010 12:04 PM
whatever Go to last post
1 35
Hi, I get this error SQL0101N error for the Select Query. I know that I am selecting all the colums from 10 tables and passing like 200 values to the...
Kiram
02-25-2010 05:45 PM
Kiram Go to last post
2 19
For DB2 Version 9.5, does setting swappiness= 0 (/proc/sys/vm/swappiness) on RHEL 5 sufficiently limit Linux file system caching, or is there some...
Mark A
02-23-2010 05:54 PM
Mark A Go to last post
4 25
Hello, i have a little performance problem with DB2 UDF: i've created 2 UDFs: EAN_128(EanCodeReq VARCHAR(4), Id bigint) returns...
boris brinza
02-23-2010 04:05 PM
Serge Rielau Go to last post
1 16
We'd like to use the auto_del_rec_obj and rec_his_retentn cfg parameters to delete old backup images and archived log files. This is working fine,...
Frederik Engelen
02-23-2010 12:21 PM
Steve Pearson (news only) Go to last post
7 46
Use IQ 20/20 to produce stunning Reports and Dashboards from your DB2 data as well as other data sources. If you have invested time and money into...
Madhan
02-23-2010 08:41 AM
Madhan Go to last post
0 13
Hi, I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except the following issue from...
Tony
02-22-2010 04:05 PM
Mark A Go to last post
3 25
Hi, I would like to use AUTHENTICATION=DATA_ENCRYPT parameter on my database for increased security. But I cannot find any in depth articles about it...
Asphalt Blazer
02-22-2010 02:18 PM
Ian Go to last post
3 23
I am running DB2 V9.5 on AIX. We have a fairly small database (2 million records max on main table). We use COUNT(*) periodically. We also...
shorti
02-18-2010 04:29 PM
Ian Go to last post
7 46
Hi, I am working with WebSphere Federation Server v9.5. for LUW Developer Edition. What are the limitations of the developer edition? I was not able...
k_rus
02-18-2010 10:19 AM
k_rus Go to last post
0 10
Hi! How does DB2 choose the victim when a deadlock is detected? Can it be configured in any way? Last night a long-running batch transaction was...
danfan
02-17-2010 05:27 AM
danfan Go to last post
1 19
Use VALUES, like this .... ------------------------------ Commands Entered ------------------------------ WITH tableA(x,y) AS( VALUES ('x1' ,...
cjflorian@gmail.com
02-15-2010 10:59 AM
cjflorian@gmail.com Go to last post
2 22
I made a web. For those people who want learn and earn by internet .please visit the...
John Smith
02-13-2010 05:09 AM
John Smith Go to last post
0 28
Hi, I'm writing scripts to monitor our databases. They should be somewhat universal, i.e. run on on DB2 versions 8+ (yes, we still have some...
Willem Fischer
02-11-2010 08:20 AM
MarkB Go to last post
1 33
I am using the db2 9.7 client software to install visual studio add- in. The error message: The operation could not be completed. The requested...
Justin
02-10-2010 10:12 AM
Justin Go to last post
0 21
Can i add the DB2 Connect Personal Edition V9.7 license file (from a commercially licensed copy) to a directory in my DB2 Express-C V9.7 installation...
Mark A
02-10-2010 08:29 AM
MarkB Go to last post
1 22
Hi all, I'm trying to install the above 2 packages on windoze 7 (64 bit) VmWare image and for both of them I get an error message saying that the...
alexs
02-09-2010 08:52 AM
kevan Go to last post
1 25
db2 => select TABNAME, CARD, FPAGES, NPAGES, OVERFLOW from sysstat.tables where tabname like 'ENTITY%' TABNAME ...
cjflorian@gmail.com
02-09-2010 12:13 AM
Hardy Go to last post
8 52
And I thought professional whiners in cdi claim that Oracle is more than IBM + Microsoft combined after IBM took over Informix. Taken from today's...
dba6319@gmail.com
02-08-2010 03:39 PM
Mark A Go to last post
2 16
"Mark A" <noone (AT) nowhere (DOT) com> дÈëÏûÏ¢ news:hk7apt$bm3$1 (AT) news (DOT) eternal-september.org... it has been years from the first time I...
Hardy
02-07-2010 01:39 PM
Serge Rielau Go to last post
3 41
Hi All, I am using DB2 9.1 on Z/OS . i have complied and run my application program which has a simple select on a table on its primary key....
Shishir
02-07-2010 11:21 AM
Mark A Go to last post
1 16
Yellowfin Business Intelligence an entirely new dimension in Location Intelligence has provide Jet Interactive with a significant competitive...
JTP PR
02-07-2010 12:19 AM
JTP PR Go to last post
0 26
I'm working on some deadlock analysis, and when I parse the output of the deadlock event monitor, I discover that for over half of my 26 deadlocks in...
Ember
02-05-2010 10:38 AM
whatever Go to last post
3 46
I have two question, we are using the "with ur" in some sqls that can read uncommitted rows, so that has improved concurrency, but "for read only" is...
Arun Srini
02-05-2010 08:21 AM
MarkB Go to last post
6 49
I'm looking for documentation on db2pd that is complete to some extend. At the moment I'm doing a lot of guesswork, but there must be many more...
Willem Fischer
02-05-2010 01:47 AM
Willem Fischer Go to last post
3 26
Hi, I'm running Db2 V9.7FP1 64 bit on two Linux servers. I've got a number of databases living on the "primary" server that I'd like to replicate...
alexs
02-01-2010 11:05 PM
Serge Rielau Go to last post
3 42
Hi All. I just trying to understand why a stored procedure call takes more time to response than an ODBC request. My company use JDEdwards with DB2...
Charlie
02-01-2010 07:57 PM
Tonkuma Go to last post
6 39
Post New Thread

Display Options
Showing threads 1 to 50 of 11259
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.