User-Defined Function (UDF) and Single-Threaded Jobs

Resolving The Problem

The following errors can occur when running a SQL statement with using a user-defined function (UDF). The UDF may also be part of a view. Some system views were changed to be run in a separate thread at R610. The following messages can occur if the job is not a multi-threaded job:

o Message CPD000D
o Message SQL0443
o Message CPF503E


Use DSPSYSVAL QMLTTHDACN to see if the machine is configured as Option 3. If it is, this must be changed to Option 2.

                              Display System Value                              
                                                                               
System value . . . . . :   QMLTTHDACN                                          
Description  . . . . . :   Multithreaded job action                            
                                                                               
                                                                               
Multithreaded job                                                              
  action . . . . . . . :   2          1=Perform the function that is not      
                                        threadsafe without sending a message  
                                      2=Perform the function that is not      
                                        threadsafe and send an informational  
                                        message                                
                                      3=Do not perform the function that is    
                                        not threadsafe