my system name is radx, and also my system log  in name is radx, when i
i tried to create user with name in manage user window ,
it show "system and username does not same".
ok, changed to rad_x and belong him to the group og adminstrators.

Hi  all,
Quick question, which strangly I just cannot find many results for.
Client, Solaris 10
Server, V4R5

2006-08-14-17.46.13.656000-240 I1472H436          LEVEL: Warning
PID     : 1452                 TID  : 336         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : SQ4V6
APPHDL  : 0-9                  APPID: *LOCAL.DB2.060814214011

We are getting this error every other day during the ETL run.  It seems
to be random.  What is the best solution?
DB2 AIX 8.1.5.
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E  Invalid

Express C v9.1
I'm having a hell of a job trying to reduce the highwater mark for
various tablespaces in Express C. DB2MART advises to reorg several
tables with LONGLOBDATA and to disconnect, reconnect between each step,

Can I include an expression (e.g., concatentating 2 fields) in the
right side of a left outer join?
If so, how do I refer to the expression in the main select clause?
Thanks in advance for any thoughts,

Outside of changing the SQL of the query or creating indexes, what can
one do in order to prevent sort spills.  Im thinking along the lines of
the db cfg and dbm cfg files.  Ill post the current setup we have of
one database which is having problems with these:

is there a way in DB2 to have a db link to a remote table in SQL Server
2000 and be able to insert data in that table?
I have 2 systems that need to access the same information almost real
time (one app uses SQL Server and the other uses DB2) so immediately

We're running AIX 5.3 and DB2 v8.1 FP 9.  Topas and lscfg confirm that
this is a 4-way SMP environment, however only 1 of the 4 processors
seems to be operative.  That is, with INTRA_PARALLEL=YES,
MAX_QUERYDEGREE=ANY and DFT_DEGREE=ANY overall processor load when

I am trying to find some information or an example on how to build a
dynamic query in DB2 that would allow me to join a table which its name
is stored as a field value on another table.
I have done this in the past in SQL server, but DB2 is not as easy...

I am using RHEL, DB2 UDB v 8.2. I have created a new database in one
system. Now I want to catalog this database in another remote system.
Do we need to set any parameters for the database? Please provide me
with a detailed step by step procedure to di this.

I need some clarification on a MERGE statement. The database is on V8
FP12 (AIX) 64bit.
The source table is tableA.
The target is a View "FACT" with UNION ALL because of the 512 Gig

Folks,
How can I copy sequence objects from one database to another?
I have a script that exports data from one database and loads it into another.
Some of the columns in the database are integer derived from sequences.

I am trying to connect to a DB2 database using "iSeries Access ODBC
Driver" from Crystal Reports. I am able to report on tables and queries
but not stored procedures. I get the following error after I select the
procedure and enter the parameter.

Is there a command line trick that inserta ascii text into a CLOB
column?
Thanks.