Thema:

Kommentar:
: Hallo Friedhelm, : Ich nehme an dass es sich um eine fenced UDF handelt. : In diesem Fall will DB2 das Speicher-Segment 0x'90000000' benutzen. Dieses Segment wird aber auch vom Database Global Memory (Database Shared Memory) benutzt, wenn dieser grösser als 1,25 GB ist. : Database Shared Memory = Summe(Bufferpools,Locklist,Databaseheap,Package chachesize) * Anzahl Databases : probier folgendes : : - verkleinern Database Shared Memory, wenn möglich : - NON fenced UDF : - setze DB2_MMAP_READ / DB2_MMAP_WRITE auf NO, wenn möglich.Damit werden 2 zusätzliche 256 MB Segmente verfügbar. : Gruss und viel Glück : Bernd : PS: Eintrag aus DB2 UDB Knowledge Base zu dem Thema : : Applicable version(s): Version 6 : Applicable platform(s): AIX : Abstract: Error message: SQL10003 is received when calling fenced user defined functions. : Symptom : Error message: SQL10003 is received when calling fenced user defined functions. : Possible cause : Fenced user defined functions (UDFs) require a shared segment to be attached to address 0x90000000 in the db2agent. : If the shared memory of the database already takes up this area (for example, it is greater than 1.25 GB) calling fenced UDFs will fail. : Further Explanation : During a trace sqlogmshr may fail with FFFFD605 and shmat call may fail with EINVAL (0000 0016 in the trace). Database shared memory segments are limited to '4'-'8' (for example, 5*256MB or 1.25 GB). : EINVAL on shmat is due to segment '9' (for example, address 0x90000000) already being in use. With fenced UDFs, the limit is 5 segments, (1.25 GBs equal to about 320000 4K pages) for database shared memory. The shared memory segment for a fenced UDF is fixed at 0x90000000 (there are no more available elsewhere in this configuration). : 6 segments is the maximum when intraparallel is enabled as the application control heap is fixed at 'a' (unless mmap services are disabled).

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: