DB2
in [SQL]
|
Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings? machineghost wrote: Wow, thanks for the replies everyone. It seems I'm facing a genuine bug here, and that my only real options are to: A) Set a character that I believe to be the rarest/least used as our termination character, modify all my SQL-generating code to use this new termination character,... 12 Jul 2008 10:30
bind file recovery I lost a bind file that I needed so I could bind a package against another (test) server. Is there a way I can 'recover' the bind file from the package it created on the first (production) server? I know I can just pre-compile the package again and get a new bind file which I can use against all of the necessary... 20 Jun 2008 13:16
How to terminate idle agents? DB2 UDB V8.2 on AIX. Is there a db2 command/function to terminate a single idle agents from the agent pool. I could kill -9 the process but I was wonder if there was a more graceful or appropriate way to do this. I did not see an API call like sqleEndCtx that could perminently remove the agent and clean up memor... 20 Jun 2008 18:25
DB2 query hours difference i need ur help. i want to have CPU utilization of last 24 hrs. for time being i want to have result from 1 server. select "AVG_%_Total_Processor_Time", "WRITETIME", "MAX_ %_Total_Processor_Time", "MIN_%_Total_Processor_Time", "AVG_ %_Total_Privileged_Time" , "AVG_%_Total_User_Time", "AVG_Context_Switches/Sec"... 23 Jun 2008 16:51
Trigger fire a query Hi everybody! I have a query which is exected by client in QMF. He is updating query predicate by entering date range and report_id and running this query. If i will create a Parm_table with date_range and report_id columns, can a trigger fire up this Query any time when Parm_table is updated. Thank's In advance... 20 Jun 2008 11:12
DB2v9.5 64-bit does not allow me to chose location of user tablespaces. Why? Hi all, We install DBv9.5 64-bit on a Linux server. While creating user tablespaces (e.g., TS0004k regular) we find that DB2 control center does not allow us to add the container location for the tablespace. DB2 automatically assigns a location which happens to be the same path as the database path. Obviously, t... 20 Jun 2008 12:14
how to reset start value of "generated always as identity" I have the following table SMV: CREATE TABLE SMV( SET_ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 500, MINVALUE 1, MAXVALUE 9223372036854775807, NO CYCLE, NO ORDER), SET_NAME VARCHAR(100) ) ; And need to migrate the contents of SMV to several separate schemas wh... 20 Jun 2008 18:25
Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings? First off, let me just say that as someone with no DBA training whatsoever, any help I can get with this issue will be very, very much appreciated. My company recently migrated our database from DB2 v7 to DB2 v9. We hired a consultant to help us, and things went pretty smoothly ... up until a few weeks after, w... 10 Jul 2008 19:36
How to get 'message text' portion of error from SP Hello All, I have a procedure that is getting -443 after upgrading to V9.5 FP1. The procedure was written to output only the SQLCODE. Here is the output that is returned: Value of output parameters -------------------------- Parameter Name : V_OUTPUT Parameter Value : ERR:-443 Return Status = 0 ... 20 Jun 2008 17:23
Control Center SQL Assist We're trying to use SQL Assist in the DB2 Control Center for DB2/LUW 9.5 and we are getting the following error: "Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553" If I try to call the SP directly I get the same error: ca... 19 Jun 2008 13:42 |