I am getting this error Package "NULLID.SYSLN30F 0X5359534C564C3031"
was not found in my application, Application is a Websphere portet and
we normally get this error after executing a specific SQL from the
application.

I am working with DB2 v9, and I am looking to create a TIMESTAMP
column in one of my tables that will automatically insert the current
date/time when I add a new row.  Is there a way to do this by
specifying a generation formula, or must I create a trigger?  Thank

I would like to gtet the unicode value of an character stored in a DB2
UTF-8 database.
For example:
having the german character "ä" (a with two dots above)

I m trying to use a query that would calculate the table size in MB s
rather than pages
The query is as follows
db2 "select rtrim(t.TABSCHEMA) || '.' || t.tabname ,npages,pagesize,

I m using db2 v8 fixpc 12 on aix
There is this particular query that i m having a problem with..
The query seems to work fine on windows v8 and v9 .
The query that i used was

Can anyone tell me the URL to download the ifo centre for v9?  I've gone
nearly blind looking for it.  
Note to IBM:  MAKE THIS STUFF EASIER.  Even the search function, when given
"db2 v9 information center download" came back with billions of entries,

1)  According to documentation, setting
    CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
    But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no value". Again, according to documentation, CATALOGCACHE_SZ is allocated "when the database is initialized". ...

When setting the locktimeout value, is it immediately changed for the
database?  or will we have to de-activate the db?  Or stop / restart
db2?
Did not see this info available on the db2 docs:

Hello, I'm posting this casually, with hope that someone can provide a
bit of guidance.  DB2 has many monitors, health, performance, etc.  My
management has asked me to provide a report on a regular basis that
would show them how well, or unwell our DB2 environment may be

I am now using db2 v8.2 64bits without DPF. I want to create a very
large table which is about 1000G and the record length is suitable for
32K page size. I find in the manual that the maximum size for 32K page
size container is 512G only. Does it mean that the maximum size for 1

Can someone explain this sorting issue?
we are using V8 on Windows, but database *might* have been created
with V7 (I can find out if it really matters)
I have a table with one column, data VARCHAR(255) . It contains three

All
Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level:
z/OS 1.6.1 @ RSU 0702.
Processor   : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit

I have a job that inserts thousands of LOBs into a table.
Under a UDB 7.2 client, it runs in four minutes.
The same job, running against the same UDB 8.2 server, takes over 30
minutes on the 8.2 client.

Can someone provide me the simple syntax necessary to insert or update
to a row containing a single BLOB column, where the BLOB data will be
obtained from a file?  This is on a linux installation.  The table has
2 INTs and 1 BLOB column.

IBM DB2 UDB
Is there a SQl query I can send from the web server that will return a
list of tables currently in the LOAD PENDING state?
LOAD QUERY is not quite waht I'm looking for.