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     
Hey guys... Just wondering about the reserved word PUBLIC used in DB2. The length of that word is 8 and it screwing with some formatting work that...
cbielins@gmail.com
03-09-2011 04:01 AM
Serge Rielau Go to last post
4 39
so we can now find DBM values inside the sysibmadm.DBMCFG table, the DB values inside the sysibmadm.DBCFG table. Where can I find the ADMIN CONFIG /...
cbielins@gmail.com
03-08-2011 02:23 PM
Will Honea Go to last post
10 58
We are running DB2 9.5 FP5 on Red Hat Enterprise Linux Server release 5.4. The server has 32GB of physical RAM. Running db2mtrk -d -v shows a total...
Desmodromic
03-07-2011 04:30 AM
Frederik Engelen Go to last post
11 87
Hi all, any comments on this one would be much appreciated: Background: somewhere in the enterprise, very occasionally, an invalid record is being...
JohnO
03-03-2011 04:48 PM
Lennart Jonsson Go to last post
3 46
Hello, DB2 LUW v9.5 FP7 running Red Hat Enterprise Linux Server release 5.3 This rather simple merge query is behaving abnormally. We...
Michel Esber
03-03-2011 08:18 AM
whatever Go to last post
18 79
I ran across this: http://davebeulke.com/db2-temporal-tables-%E2%80%93-capturing-a-snapshot- of-your-business/ The article seems to be about DB2 for...
Troels Arvin
03-02-2011 03:29 PM
Troels Arvin Go to last post
4 53
Hello. Thank you for taking the time to describe your scenario and the problem you had with the documentation for the benefit of your fellow DB2...
Bruce
02-28-2011 03:28 PM
Sarah Go to last post
9 52
I have a piece of C++ code in which I try to update a record for a primary key. If the record does not exist, an exception is raised and the data is...
Deodiaus
02-23-2011 04:40 PM
Lennart Jonsson Go to last post
2 122
I'm trying to dynamically build the values of a WHERE IN clause but I can't seem to get it to work. I'm new to writing DB2 stored procedures and...
Tito Burgos
02-22-2011 08:40 AM
--CELKO-- Go to last post
2 42
Hello, I have a trouble doing an insert from TEMP (global temporary table, on commit preserve rows, not logged) table into a permanent one: 1....
Oleg Kozlovski
02-16-2011 07:08 AM
rohan Go to last post
1 41
DB2 Express-C on XP sp3. I have a standalone DB with no online users that I use for processing association data mining rules. When I get the rules...
Fin
02-13-2011 08:18 PM
Fin Go to last post
7 34
DB2 V9.5 on AIX...I am looking for a better way to tell when runstats is needed. AUTO_MAINT AUTO RUNSTATS does not seem to do the trick so we added...
shorti
02-11-2011 03:32 AM
sanjay kumar Go to last post
1 69
when i execute get_dbsize_info to find the size of a database it is giving output as -1. Can anyone, please help me out how to resolve this issue?
kavin
02-10-2011 07:02 AM
sanjay kumar Go to last post
6 39
LUW 9.5, this may sound as a silly request, but has to do with refresh of directory cache and workspaces in RAD. Is there a function that returns the...
Lennart Jonsson
02-10-2011 06:58 AM
sanjay kumar Go to last post
6 55
I have a column in my database named signup_date with a datatype of bigint. I want to know how to convert this bigint into datetime correctly as a...
robie
02-10-2011 06:53 AM
sanjay kumar Go to last post
3 51
This paper has defined Social and Collaborative BI as the merging of BI with social networking and Web 2.0 technologies. Direct Link (No Email...
JTP PR
02-06-2011 05:05 PM
The Boss Go to last post
1 48
Hi I have a question about Shared CGTT(Global Temp Table). In one session you can share data Can I share data(In the SESSION.TMP_PROTESTTAB) with 2SP...
scv1977
02-03-2011 04:02 PM
john feng Go to last post
2 246
I'm on DB2 v9.1 on Linux. Trying to do a redirected restore of a DMS auto-resize tablespace. It seems like the first thing that DB2 tries to do on...
Greig
01-31-2011 08:37 PM
Fin Go to last post
2 47
Hello, Is there a way to get a list of tables being in the "Load Pending" state? syscat.table's status and access_mode columns don't seem to be...
Troels Arvin
01-31-2011 09:28 AM
The Boss Go to last post
4 51
While installing Db2 V9.7 WSE on AIX 6.1, I got the below error, has anybody got this and how did you solve : Task #42 start Description:...
Raj
01-30-2011 09:35 AM
Mark A Go to last post
4 42
Hi, When defining your disk location as to where you are going to archive your log files, can you put them on the same file system (ie....
Chris Briel
01-28-2011 03:47 PM
Helmut Tessarek Go to last post
1 41
All - Aix 6 with DB2 UDB 9.1.4 I've got thousands of indexes in a single tablespace (this is a purchased app...I didn't do this...). I need to...
Bruce
01-28-2011 10:26 AM
Bruce Go to last post
2 43
In the 9.7 Upgrade roadmap it says: Upgrading a primary database to DB2 Version 9.7 changes the database role from primary to standard. Upgrading...
Richard
01-28-2011 08:10 AM
Mark A Go to last post
3 59
I am attempting to update one column in a table with the value from a second table, using the code below: UPDATE TABLEA SET (PYMT_BEFORE_MOD) = ...
Joe
01-27-2011 10:12 PM
Serge Rielau Go to last post
4 54
Hello, I am running DB2 V9.7 ESE on AIX. The current database has the indexes contained inside the tablespaces. For performance purposes we are...
shorti
01-27-2011 05:29 PM
shorti Go to last post
2 53
Hello, Regarding reclaimable storage: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0055392.html...
Troels Arvin
01-25-2011 02:49 AM
Kel Go to last post
1 41
Are there any examples of programs doing DDF accounting in DB2? Thank you, DO
Devout Occamist
01-19-2011 08:07 PM
Helmut Tessarek Go to last post
3 49
Hello, Setup: Latest 64-bit Windows client on Windows Server 2008 connecting to a DB2 9.7 server (running on Linux) with latest fixpack. The...
Troels Arvin
01-19-2011 08:23 AM
Troels Arvin Go to last post
13 82
Hi there, I'm running DB2 9.5 under Linux and I'm trying to run the CREATE SERVER command, but I get an error message about the authorization id and...
Bill
01-18-2011 04:36 PM
The Boss Go to last post
3 52
Hello, Let's say I have a large table which needs to be reloaded from scratch with (lots of) new data. The table has a clustering index and a...
Troels Arvin
01-18-2011 01:07 PM
Mark A Go to last post
3 45
All, DB2 LUW v9.5 FP 5. Has anyone implemented or could point articles to an UDF that returns the Subnet ID of a (IP, NetMask)...
Michel Esber
01-15-2011 02:05 PM
Lennart Jonsson Go to last post
4 42
Guys, DB2 LUW v9.5 fp5 Not sure if I am missing something obvious, but: select MIN(COLLECT_TIME), MAX(COLLECT_TIME)...
Michel Esber
01-15-2011 11:02 AM
Ian Go to last post
3 45
We've just migrated, in our development environment, an 8.2 instance to 9.7. The developers started to test their apps against the 9.7 database, and...
Richard
01-13-2011 10:03 AM
Richard Go to last post
3 57
Hello Lennart, In comp.databases.ibm-db2, you recently wrote: Ah, it's to be interpreted as a tablespace container file, it seems. I would very...
Troels Arvin
01-12-2011 04:03 PM
Troels Arvin Go to last post
2 53
Anybody has experience restoring 9.5 database back to 9.1 ? Our environment is WIN 2003 64 bit. Thank you in advance. By the way, any doubt I had...
Richard
01-10-2011 01:13 PM
Serge Rielau Go to last post
8 55
The event monitors are explained in great detail...
Willem Fischer
01-07-2011 10:27 AM
The Boss Go to last post
1 55
The event monitors are explained in great detail...
Willem Fischer
01-07-2011 08:12 AM
Willem Fischer Go to last post
1 56
I found that truncate table statement is not correctly replicated via ASN replication. Truncate is rollforward compatible, so capture program should...
hsn_
01-05-2011 11:37 AM
Naresh Chainani Go to last post
1 44
All right I bite, with the disclaimer that this is my personal opinion. If you see a feature a s a dimension, then with every feature that you add a...
Serge Rielau
12-21-2010 05:29 PM
Will Honea Go to last post
6 43
hi, is this normal for bp hit ratio to be low and asynchronous reads ratio to be high while running runstats with distributions ?
db2admin
12-21-2010 05:08 PM
Frederik Engelen Go to last post
2 52
Anybody have a copy of Version 8 for Windows install? I have a backup of a system and need to restore to the same version. Thank you
Ralph Young
12-17-2010 05:47 AM
Mark A Go to last post
1 54
I realize this topic has been covered many times. I'm looking at the 9.7 upgrade steps outlined on the IBM website. It says, for 8.2 databases, I...
Richard
12-16-2010 11:07 AM
Richard Go to last post
5 40
Greetings, how can I find out what MQTs are defined on a particular table? Regards, Damir
Damir
12-11-2010 11:59 PM
Lennart Jonsson Go to last post
3 63
Hi folks, Is it possible to create a task right from the DB2 CLP instead of using the IBM Task Center (GUI) ? DB2 DEV server : DB2 Express-C /...
Charles M.
12-11-2010 03:38 AM
Frederik Engelen Go to last post
9 51
hi, we have some server connecting to database server running 9.5 FP 4 on AIX and locking account. this server must have wrong password. how to find...
db2admin
12-06-2010 02:07 PM
Frederik Engelen Go to last post
1 48
Hi, Db2 LUW v9.5 fp5. Following this thread: http://tinyurl.com/36hhfqf create view testing_predicate_pushdown as with disks as (
Michel Esber
12-02-2010 11:22 AM
ChrisC Go to last post
4 61
Hi, I found that simply copying a databases' files to the target directory (C:\MYINST) and then doing "db2 catalog db MYDB" works better than...
Willem Fischer
12-01-2010 01:03 PM
Helmut Tessarek Go to last post
2 52
We have setup a new physical server, with a number of virtual servers on top of it. When we run db2start on any of the virtual servers we get: ~]$...
Lennart Jonsson
11-30-2010 01:52 AM
Lennart Jonsson Go to last post
5 54
What is the best way to identify which statements in the package cache that reads from a certain table? I'm not to happy with: select ... from...
Lennart Jonsson
11-25-2010 06:16 PM
Willem Fischer Go to last post
5 54
We're in the planning stages for a DB2 upgrade from 8.2 & 9.1 to 9.7 FP3a. I've never applied a fix pack or upgraded an instance to a newer version....
Richard
11-25-2010 12:15 AM
Helmut Tessarek Go to last post
2 55
Post New Thread

Display Options
Showing threads 351 to 400 of 9426
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 - 2014, Jelsoft Enterprises Ltd.