DB2
in [SQL]
|
What's the meaning of IID=0 in output of db2pd command In output of comand "db2pd -d <dbname> -tcbstats index", what's the meaning of IID=0? Please advise. Thanks so much. James ... 10 Jul 2008 11:20
User-defined aggregate functions and OLAP windowing Friends: In v8 or v9 LUW, if I were to write (in Java or C) my own user-defined aggregate function, would I be able to use it in an OLAP windowing clause as I could use, e.g., COUNT or SUM? Example: SELECT JEFFS_UDAF() OVER(PARTITION BY SOME_COL) FROM SOME_TABLE; --Jeff ... 10 Jul 2008 05:10
about online reorg Hi, Just wondering, is there any way to do the online reorg to use temporary tablespace instead of tablespace table existed. since that is really a waste to have some space allocated aside only for the online reorg .. I know offline reorg could use temporary tablespace ..is that so difficult to add this... 18 Jul 2008 14:26
How to connect IBM DB2 with JSP? Hello everyone. I m having my databse in access till now. Now i want to use IBM DB2, can you help me by telling how to connect the IBM DB2 with a JSP application? Thanks Kartikeya ... 9 Jul 2008 16:48
notify/listen? Hi there, can somebody tell me if there is a mechanism in db2 which implements a notify/listen for external db clients? Postgres has such a mechanism where a client programm can connect to the db and send a "listen <name>" sql command and then gets a message if someone in the system issued a "notify <name>". Th... 10 Jul 2008 12:22
Tablespace qualifier in DB2 UDB On Linux/Unix/Windows Hello, I am a DB2 DBA on IBM Mainframe environment. I recently started learning DB2 on Unix/Windows environment. Can any one answer the following questions: 1. What is the qualifier that is used to identify tablespaces in DB2 UDB on Linux/Unix/Windows environmet? On z/OS, it is the database name that qualifies ... 9 Jul 2008 20:55
backup falsely marked as in progress. can i clear this state? Hello, db2v9.1 fix pack 1 on sun solaris 2.10 every night we do an online backup on this system. (db2 & netbackup) last night netbackup had a problem and the process died on the netbackup side before the db2 backup completed. DB2 did not get the death notice and now it says I can not do another backup becaus... 9 Jul 2008 11:38
store procedure error Hi, i am getting error while executing the store procedure db2 "CALL CRS.UPDATE_DEAD_RECORD2(')" SQL0444N Routine "*_RECORD2" (specific name "SQL080221165103852") is implemented with code in library or path "...tine/sqlproc/NDB_PROD/CRS/P6510378", function "*" which cannot be accessed. Reason code: "4". SQ... 11 Jul 2008 06:51
How to LOAD deleimited data with linefeeds to mainframe DB2 Good Morning. We used LOAD with DELPRIORITYCHAR to load delimited data to a UDB DB2 which may have line feeds in the string fields. We need to be able to do the same for a customer on DB2 z/OS Vers. 8, but I do not see this paramteter in the utility guide, nor any mentioned on how to handle this issue. any su... 9 Jul 2008 07:32
SERGE I AM TRYING IPLEMENT YOU TRIGGER You won't be able to bend an INSERT to a MERGE using a BEFORE trigger. The only way I can think up to achieve what you want is to use an INSTEAD OF trigger. Today these triggers are defined on VIEWs only. So: CREATE VIEW T AS SELECT * FROM TBASE; CREATE TRIGGER trg1 INSTEAD OF INSERT ON T REFERENCING NEW AS n F... 9 Jul 2008 18:52 |