GENERATE_UNIQUE performance function

AlbertoR · New User Joined: 28 Sep 2007 Posts: 4 Location: Bilbao

Hi,

I'm thinking about using GENERATE_UNIQUE function to identify and I would like to know if the would be a lack of performance if there are many executions of the function at the same time. It would be a big queue of the requests of the function?

Thank you,

Alberto

vasanthkumarhb · Posted: Thu Oct 25, 2007 4:59 pm

Hi,

Please frame the question properly according to your query.

Regard's
Vasanth

AlbertoR · New User Joined: 28 Sep 2007 Posts: 4 Location: Bilbao

Hi,

Sorry for my English

.

I want to use GENERATE_UNIQUE function to identify the rows.

The question is if this function get many load of CPU, get down the performance and if how many executions at the same time of this function could be?

Thank you

vasanthkumarhb · Posted: Fri Oct 26, 2007 9:50 am

Hi Albert,

Pls find the below link, it may helps you a lot.

publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sample.doc/doc/cobol_mf/s-impexp-sqb.htm

Regard's
Vasanth........

AMITESH · New User Joined: 28 Feb 2008 Posts: 3 Location: kolkata

Hi,

Is this function is only for a particular version of DB2?

i am trying to use this function.but at run time it gives the following error message.......................

SQLCODE = -440, ERROR: NO FUNCTION BY THE NAME GENERATE_UNIQUE HAVING
COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH

Gnanas N · Posted: Thu Apr 17, 2008 4:05 pm

What's your DB2 version?

Gnanas N · Posted: Thu Apr 17, 2008 4:57 pm

GENERATE_UNIQUE() SQL function from DB2 UDB Version 6.1

Although the function has no arguments, the empty parentheses must be specified when the function is invoked.

AMITESH · New User Joined: 28 Feb 2008 Posts: 3 Location: kolkata

db2 version is 7.2

is it version specific???