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 a warning but it still creates the alias for an object which
is not even present.

hai everyone....
                         Can anyone say how to find the user name who
attached to the instance...........
regards...

Are there java API that can be used to gain similar functionality as
db2ilist, db2 CLP?
Thanks,
MarcM

v8.2.
Is it possible?
Example:
---------------

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 db2setup.
The message shown -

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 on a DB2 database from a web app, specifically when the web
site does XYZ, what SQL does it run on the DB2 database?  Unfortunately

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 server or other database user) should
not access database. means database should be offline to application

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 refresh
after creating the staging table.
I tried set integrity immediate unchecked, but refresh table after that

I have a shell script that I am using the db2 load command to populat
my table with.  I have a problem with the dates though.  In my fil
that I am populating the table with, I have 3 date fields that get ar
in the format yyyy-mm-dd.  The table has these columns set a

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 connecting using the iSeries Access ODBC Driver.
Both the tables in both tables are identical in terms of columns and

I have a shell script I am trying to run that loads a table from
control file.  The file I am trying to load is delimited by the "}
character.  How do I set the delimeter code?  Here is my loa
statement:

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 have whare are the
folders that I need to take the backup after shutting down the DB2?

Hi people,
I have a stored procedure that creates many [8] Global temporary
session tables. Into each of these tables go the results of various
processing using relational division all keyed and based on a common ID

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 3

I have a procedure that is compiled in the database and I can also recompile
it without any problems, but when I call it I get this strange error:
[IBM][CLI Driver][DB2/NT] SQL0727N  An error occurred during implicit system
action type "1".  Information returned for the error ...