| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi All,
In Ops Nav, it's possible to display the current SQL being executed by
a job. However it's rather slow to find the job as it has to populate...
JohnO
|
06-23-2006 04:31 AM
JohnO  | 2 | 63 |
| | | Hi
I have an access violation in DB2SYS.dll at each ending of my
application.
This is a multithreaded application. Threads are created and managed...
alinehp
|
06-23-2006 03:22 AM
alinehp | 4 | 60 |
| | | hello all,
i have installed a db2 version 8.2 FixPak 4, problem is it is not
showing any of the tool properly.
i.e whenever i try to open...
situ
|
06-22-2006 11:32 PM
situ | 2 | 66 |
| | | Apparently db2 provides two forms of an error message, one more readable
then the other. The readable one is apparently parsed from the other
one....
Bob Stearns
|
06-22-2006 04:54 PM
Bob Stearns | 0 | 67 |
| | | hai everyone...
i have a scenario here....... i have a database in
a instance......... mistakenly i dropped the instance . i have all the
database...
Gladiator
|
06-22-2006 02:38 PM
db2dude | 8 | 125 |
 | | I have a shell script I am trying to run that loads a table from a control file. The file I am trying to load is delimited by the "}" character. ... jrthor2 |
06-22-2006 12:11 PM
jrthor2 | 7 | 406 |
| | | Hi:
First, thank you for looking into this posting...
Running UDB V8 FP11.
The question is around the below query branch. I would like to know
what...
UDBDBA
|
06-22-2006 11:49 AM
UDBDBA | 2 | 76 |
| | | Hi,
An alias is an alternate name for a table or a view. Now, suppose I
create an alias on a non existent table in the control centre , it
gives me...
rAinDeEr
|
06-22-2006 11:32 AM
Ian | 6 | 97 |
| | | hai everyone....
Can anyone say how to find the user name who
attached to the instance...........
regards...
kamal
Gladiator
|
06-22-2006 11:07 AM
UDBDBA | 2 | 138 |
| | | Are there java API that can be used to gain similar functionality as
db2ilist, db2 CLP?
Thanks,
MarcM
Marc Melancon
|
06-22-2006 08:30 AM
mike | 4 | 78 |
| | | Material on Win runner, Load Testing, Unit Testing and Much More...
Articles, Methodologies, Q&A on Software Testing Techniques &...
AT
|
06-22-2006 08:04 AM
AT | 0 | 66 |
| | | Hello.
v8.2.
Is it possible?
Example:
---------------
create function t(v varchar(1))
modifies sql data
returns table(c varchar(1))
AT
|
06-22-2006 06:52 AM
AT | 2 | 73 |
| | | Hi there,
I have searched a couple of keywords for db2setup issue, but find out
nothing.
I'm tring to install DB2_ESE_8.2_LNX on RHEL AS 4 by using...
Laurence
|
06-22-2006 01:28 AM
Laurence | 4 | 64 |
| | | Hi,
I'm a SQL Server DBA, but I guess that won't buy me any friends round
here huh? ;-) I've been asked to look at the SQL that's being
executed...
AT
|
06-21-2006 06:27 PM
AT | 9 | 61 |
| | | Hi All
I am design one web database.
In this database i want to execute one routine At the time of execution
of this routine,User (application...
Suresh
|
06-21-2006 03:14 PM
Pierre Saint-Jacques | 2 | 71 |
| | | I want to create an MQT, intialize it manually and then use staging table to
refresh it with new data, but i don' t see a way for not doing full...
Klemens
|
06-21-2006 12:55 PM
Shashi Mannepalli | 6 | 72 |
| | | I have a shell script that I am using the db2 load command to populate my table with. I have a problem with the dates though. In my file that I am... jrthor2 |
06-21-2006 10:37 AM
Ian | 2 | 212 |
| | | Hello group,
for those who "need" to run DB/2 V5.2 on Windows XP SP2 or Windows 2003
Server SP1 i found a fix for the access-violation of db2cc.exe...
de.unger
|
06-21-2006 08:05 AM
de.unger | 0 | 75 |
| | | Hi,
I'm new to AS400 and am trying to copy the contents of a table from an
SQL Server 2000 table to a table in AS400, I'm doing this using DTS.
I'm...
accyboy1981
|
06-21-2006 07:42 AM
Larry | 1 | 105 |
| | | Dear All
Please help me asap
I have DB2 production installations.. I need to take a cold backup of
the Db2 database. Version is 8.1.7.. So can I...
Santhosh
|
06-20-2006 12:48 PM
Pierre Saint-Jacques | 3 | 79 |
| | | I feel hard to understand the tables structure and your required
result, mainly my poor English capabilities.
Especially, this part is difficult for...
p175
|
06-20-2006 10:57 AM
p175 | 15 | 175 |
| | | hi all,
this is the procedure i have created
CREATE PROCEDURE XIREL2.proc_size_2 (p_dummy CHAR(1))
SPECIFIC XIREL2.proc_size_2
DYNAMIC RESULT SETS...
situ
|
06-20-2006 10:10 AM
Raj | 1 | 64 |
| | | Gregor Kovač wrote:
Send me a repro script. I'll take a look.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
Thames
|
06-20-2006 09:09 AM
Serge Rielau | 17 | 164 |
| | | Hi,
When executing a quiesce immediate on a database does the command
wait for all connections to be off the database before completing or
does it...
AT
|
06-20-2006 09:03 AM
Jayesh Thakrar | 1 | 91 |
| | | Which scalar function would be suitable for me to extract the date out
of the following string:
"060618154449"
Thanks a lot for any advice.
Jo
|
06-20-2006 04:33 AM
Tonkuma | 4 | 109 |
| | | Hi.
I have two physical files on an iSeries (AS/400) box, from which I
would like to make a join logical file.
The files are in a master-detail...
AT
|
06-20-2006 04:33 AM
AT | 0 | 73 |
| | | would any body help me to create a database in utf codeset which
supports japanese language and settings involved in them.
thanks and regards
situ
situ
|
06-20-2006 03:00 AM
Mark A | 3 | 103 |
| | | or any other special characters? I just want to find a way can be used
in clp mode...
thank you~~
Hardy
|
06-20-2006 02:23 AM
Hardy | 1 | 85 |
| | | Is there code for the DB2 Information Integration wrappers that runs
on a Linux AMD 64 (kernel 2.6) machine. I can find the 32 bit Linux
wrappers on...
Lorne Sunley
|
06-19-2006 10:40 PM
Darin McBride | 3 | 64 |
| | | I have an employee table with two columns, one named login, the other
named otherdata.
I have a list of login values, some of which do not exist in...
AT
|
06-19-2006 07:26 PM
AT | 5 | 62 |
| | | Is it possible to load more than 1 table using the LOAD utility?
Cheers,
San.
shsandeep
|
06-19-2006 01:44 PM
Knut Stolze | 3 | 76 |
| | | Can we create an event monitor for statements in a partitioned
environment?
CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO...
Raj
|
06-19-2006 11:39 AM
Raj | 4 | 70 |
| | | DB2 Express C (Fixpack 10, WR21362_15462) seems to be lacking some of
the OLAP functions available in other editions, such as ROW_NUMBER,
RANK and...
mecej4 (AT) gmail (DOT) com
|
06-19-2006 03:06 AM
Knut Stolze | 4 | 79 |
| | | Hi everyone,
Can anyone answers my questions. My server is AIX and is 5.2 and the
db2 udb of V 8.1 Fixpak 9.
What exactly is the tools catalog...
sandeep.manthena (AT) gmail (DOT) com
|
06-18-2006 05:00 PM
sandeep.manthena (AT) gmail (DOT) com | 2 | 75 |
| | | Thanks in advance for your help.
Given the following table:
CREATE TABLE T1 (
seq INTEGER NOT NULL,
value CHAR(1) NOT NULL)
INSERT INTO TABLE T1...
Fred
|
06-17-2006 10:54 PM
Tonkuma | 13 | 166 |
| | | I am trying to build a java stor proc from RAD and i get this error:
###########################################################
CONTROL.INIT -...
technocrat
|
06-17-2006 10:45 AM
technocrat | 0 | 73 |
| | | Dirk Deimeke wrote:
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD...
mike
|
06-16-2006 07:19 PM
Dirk Deimeke | 4 | 79 |
| | | Dear all,
Is it possible to upgrade DB2 WSE to ESE for AIX directly? Or it need
to uninstall WSE then install ESE?
Thanks in advance,
Laurence
Laurence
|
06-16-2006 11:14 AM
Darin McBride | 1 | 63 |
| | | Our company has just bought an ERP system called Frontier that runs on an
AS400 and uses DB2.
Does anyone know of suitable reporting engine that...
Nexus
|
06-16-2006 10:02 AM
Peter Guetens | 1 | 74 |
| | | We are currently implementing an enterprise datawarehouse using IBM
DB2. The Finance group will be the early adopter of the datawarehouse
via a...
Umar Reyi
|
06-16-2006 05:47 AM
Umar Reyi | 0 | 65 |
| | | hi, i have DB2 8.2 on linux and when i start a script to backup the DB
, i receive this message on db2diag.log;
ADM7508E Database quiesce request...
kaissoun
|
06-16-2006 04:52 AM
kaissoun | 2 | 93 |
| | | I just created a new user and granted connect and select on a single
view, only. When I connect to my database, the new user has at least
select...
Bob Stearns
|
06-16-2006 02:48 AM
Knut Stolze | 14 | 113 |
| | | maybe your environment could support DB2CLI.INI parameter TxnIsolation
1
although you dont mention your operating system, and database...
mike
|
06-16-2006 02:34 AM
mike | 0 | 66 |
| | | Hello, I have a requirement to delete millions of rows from a table
which has billions of rows. Hence I have coded a korn script to delete
rows...
Sam Durai
|
06-15-2006 10:15 PM
Serge Rielau | 4 | 76 |
| | | I am able to connect to a Z/OS thru an AIX gateway, but when I try to do
select 1 from sysibm.sysdummy1
I get the following error:
SQL0551N ...
shsandeep
|
06-15-2006 03:02 PM
Jeroen van den Broek | 1 | 88 |
| | | I have installed DB2 8 on a VMWare image. All good so far. Then I made
a copy of that VMWare image, gave it a new name and hey presto, new
machine....
AT
|
06-15-2006 01:47 PM
AT | 2 | 76 |
| | | hi...I am very new to DB2 Cube views, I worked with MS Analyis services
earlier and this is new assignment for me to work with DB2 Cube views, Can
I...
ravindra4s
|
06-14-2006 04:52 PM
Larry | 2 | 86 |
| | | I am connecting to a linux based db2 v8.1.9. I want to use CLIENT USERID
in my views to perform data restriction. Unfortunately it not set inside
an...
Bob Stearns
|
06-14-2006 01:16 PM
Bob Stearns | 2 | 71 |
| | | Hi All;
We have many production jobs that "load from cursor" to a UDB/AIX 8.2
(with dpf) data warehouse from source tables residing Oracle 9i....
peteh
|
06-14-2006 11:51 AM
DA Morgan | 14 | 137 |
| | | Hello All,
Recently I reviewed an IBM Red Book about DB2 Performance, and one of
the topics mentioned that DB2 uses Kernel Asynchronous I/O when...
rdtbra
|
06-14-2006 10:55 AM
rdtbra | 0 | 72 |
