Tag Info

Hot answers tagged

3

You say that your procedure has two parameters: an input INTEGER and an output VARCHAR, however, you call a procedure with only one argument, therefore DB2 is looking for the procedure that has only one INTEGER argument. You should call it like so: call ADMINIST.LOG_MSG_TEST(1,?); where the question mark is a placeholder for the output argument.


2

There was no change that I am aware of in Fixpack 5 to the requirement that the registry variable DB2_COMPATIBILITY_VECTOR must be set to MYS for the ... LIMIT x OFFSET y functionality to work. (Unsetting it in FP5 still results in an error if you try to use LIMIT / OFFSET). You may want to look to see if DB2_COMPATIBILITY_VECTOR is set in the global ...


2

LOG_CONF_BP is a bufferpool. That is a chunk of memory dedicated to doing something (usually servicing one or more tablespaces, which is where tables reside). So what is happening is your stored procedure is trying to create an object that already exists. So what is going to need to change is the stored procedure. I would ask if your stored procedure needs ...


2

In situations where one static sql (procedure) executes better than an equivalent one, I would examine: a) whether this depends on the order of execution, i.e. does the second one benefit from the first one reading data from disk into the bufferpool? If one runs better than the other regardless of the order they are run in this is not the case. b) are the ...


1

You don't specify what "first" means (or provide any table structure or example data), but let's assume it's the earliest completion timestamp: SELECT entity, min(completion_ts) FROM your_table GROUP BY entity If you are just getting results for a single entity, you can simplify even more: SELECT min(completion_ts) FROM your_table WHERE ...


1

The IXF format is documented in the manuals. Conceivably, if other methods don't work as you would like them to, you could write a script to extract column definitions.



Only top voted, non community-wiki answers of a minimum length are eligible