Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. FUNCTION: DB2 UDB, oper system services,
  2. sqlo_waitlist::initialize, probe:10
  3. MESSAGE : SysV semget failed with errno:
  4. DATA #1 : Hexdump, 4 bytes
  5.  
  6. ]$ cat /proc/meminfo
  7. MemTotal: 12140640 kB
  8.  
  9. ]$ ipcs -l
  10. [...]
  11. ------ Semaphore Limits --------
  12. max number of arrays = 3072
  13. max semaphores per array = 250
  14. max semaphores system wide = 256000
  15. max ops per semop call = 32
  16. semaphore max value = 32767
  17.  
  18. ]$ ipcs -s | grep db2fenc1 | wc -l
  19. 2800 [1]
  20.  
  21. ]$ db2stop force
  22.  
  23. CREATE FUNCTION NYA.REMOVE_DIACRITICS( S VARCHAR(50))
  24. RETURNS varchar(50)
  25. FENCED THREADSAFE
  26. DETERMINISTIC
  27. NO SQL
  28. LANGUAGE JAVA
  29. PARAMETER STYLE JAVA
  30. RETURNS NULL ON NULL INPUT
  31. EXTERNAL NAME
  32. 'StringUtil:se.vhs.nya.framework.common.util.db.DiacriticUtil!removeDiacritics'
  33. NO EXTERNAL ACTION @
  34.  
  35. CREATE TABLE ...
  36. ( [...]
  37. , <COLNAME2> VARCHAR(25) NOT NULL
  38. GENERATED ALWAYS AS ( NYA.REMOVE_DIACRITICS( <COLNAME1> ) )
  39. , [...] ) @
  40.  
  41. (JAVA_HEAP_SZ) = 2048
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement