cancel
Showing results for 
Search instead for 
Did you mean: 

issue with spool work process

Former Member
0 Kudos

Hello ,

In our production environment we had increase the Number of spool work processes form 1 to 2.

Problem is even though my print queue is very large, my second spool work process doesn't process any request.

It remains idle all the time.

Kindly guide me regarding this

Thanks,

Chandresh Pranami.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

I restarted the sever.

Idle means even if my print queue is very large, my second spool work process doesn't process any request.

In sm50 status is waiting.

0 Kudos

hello chandresh

to use the effects of more than 1 SPO-WP there have to be 3 as a minimum.

(one is reserved to manage the others).

kind regards

rolf

Former Member
0 Kudos

can anybody help me regarding this????

Chandresh Pranami

lakshminarayanan_m
Contributor
0 Kudos

Hi,

After adding the spool- WP did you restart your production system.

And you are saying that WP in idle , it means wat is the correct

status in the sm50.

regards

MLN

Former Member
0 Kudos

We have not setup operation modes.

Spool Work Processes Log,

**Work Process which is processing requests,**

*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 02

M sid AWP

M systemid 274 (HP (IA-64) with HP-UX)

M relno 7000

M patchlevel 0

M patchno 159

M intno 20050900

M make: single threaded, Unicode, 64 bit, optimized

M pid 20553

M

M

M Thu Oct 16 20:19:00 2008

M kernel runs with dp version 237000(ext=110000) (@(#) DPLIB-INT-VERSION-237000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q01=> ThInit, WPStart (Workproc19 1 20553) [thxxhead.c 1281]

M ThInit: running on host awpa

M calling db_connect ...

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@AWP on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0x60000000039cf6c0 0x60000000039d7190 0x60000000039e7968

C Attaching to DB Server AWP (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08)

C Starting user session (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08,usrhp=0x60000000039d79a8)

C Now '/@AWP' is connected: con_hdl=0, nls_hdl=0, session_id=217.

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0x60000000039e7898,usrhp=0x60000000039d79a8)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@AWP on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0x60000000039cf6c0 0x60000000039d7190 0x60000000039e7968

C Starting user session (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08,usrhp=0x60000000039d79a8)

C Now 'SAPSR3/<pwd>@AWP' is connected: con_hdl=0, nls_hdl=0, session_id=217.

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance AWP is running on awpd with ORACLE version 10.2.0.2.0 since OCT 16, 2008, 20:15:09

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20081016 201900 awpd

C build_stmt: reallocating stmt buffer: 256 -> 2000 characters

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip

I

I Thu Oct 16 20:19:02 2008

I MtxInit: 19 0 0

M SHM_PRES_BUF (addr: 0xc000000128000000, size: 20000000)

M SHM_ROLL_AREA (addr: 0xc00000012a000000, size: 134217728)

M SHM_PAGING_AREA (addr: 0xc000000132000000, size: 134217728)

M SHM_ROLL_ADM (addr: 0xc00000000a975000, size: 2672386)

M SHM_PAGING_ADM (addr: 0xc000000006d00000, size: 656416)

M ThCreateNoBuffer allocated 560152 bytes for 1000 entries at 0xc00000013a002000

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12176 bytes (50 server) at 0xc000000006cb7000

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 19 initializing ....

X Using implementation std

X <ES> Info: use normal pages (no huge table support available)

X ES initialized.

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 0xc00000013a08c090, size: 576)

B dbntab: Buffer FTAB(anchor array) (addr: 0xc00000013a08c2d0, size: 480104)

B dbntab: Buffer FTAB(item array) (addr: 0xc00000013a101640, size: 1920000)

B dbntab: Buffer FTAB(data area) (addr: 0xc00000013a2d6240, size: 61440000)

B dbntab: Buffer IREC(hash header) (addr: 0xc00000013dd70090, size: 576)

B dbntab: Buffer IREC(anchor array) (addr: 0xc00000013dd702d0, size: 480104)

B dbntab: Buffer IREC(item array) (addr: 0xc00000013dde5640, size: 480000)

B dbntab: Buffer IREC(data area) (addr: 0xc00000013de5a940, size: 8192000)

B dbntab: Buffer STAB(hash header) (addr: 0xc00000013e62c090, size: 576)

B dbntab: Buffer STAB(anchor array) (addr: 0xc00000013e62c2d0, size: 480104)

B dbntab: Buffer STAB(item array) (addr: 0xc00000013e6a1640, size: 480000)

B dbntab: Buffer STAB(data area) (addr: 0xc00000013e716940, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 0xc00000013ea06090, size: 2976)

B dbntab: Buffer TTAB(anchor array) (addr: 0xc00000013ea06c30, size: 480104)

B dbntab: Buffer TTAB(item array) (addr: 0xc00000013ea7bfa0, size: 1200000)

B dbntab: Buffer TTAB(data area) (addr: 0xc00000013eba0f20, size: 8760000)

B db_con_shm_ini: WP_ID = 19, WP_CNT = 23, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 0xc000000144011420)

B dbtbxbuf: Buffer TABL (addr: 0xc000000147000110, size: 100000000, end: 0xc00000014cf5e210)

B dbtbxbuf: Buffer TABLP (addr: 0xc00000014d000110, size: 61440000, end: 0xc000000150a98110)

B dbexpbuf: Buffer EIBUF (addr: 0xc000000151000120, size: 40960000, end: 0xc000000153710120)

B dbexpbuf: Buffer ESM (addr: 0xc00000001d800120, size: 4194304, end: 0xc00000001dc00120)

B dbexpbuf: Buffer CUA (addr: 0xc00000013f401120, size: 10240000, end: 0xc00000013fdc5120)

B dbexpbuf: Buffer OTR (addr: 0xc000000127800120, size: 4194304, end: 0xc000000127c00120)

B dbcalbuf: Buffer CALE (addr: 0xc00000000ac03000, size: 500000, end: 0xc00000000ac7d120)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 0x6000000003cdec90

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 2 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S creating spool memory service RSPO-RCLOCKS at 0xc00000013fdc6080

S doing lock recovery

S setting server cache root

S using server cache size 100 (prof=100)

S creating spool memory service RSPO-SERVERCACHE at 0xc00000013fdc68e0

S using messages for server info

S size of spec char cache entry: 297032 bytes (timeout 100 sec)

S size of open spool request entry: 2272 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A PXA

A PXA IN ITIALIZATION

A

A Thu Oct 16 20:19:03 2008

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 15608kb, dir_size: 15516kb.

A Attached to PXA (address 0xc000000154000000, size 400000K)

A abap/pxa = shared unprotect gen_remote

A PXA INITIALIZATION FINISHED

A PXA

A

A ABAP ShmAdm attached (addr=0xc00000001e5d2000 leng=20955136 end=0xc00000001f9ce000)

A >> Shm MMADM area (addr=0xc00000001eac9f90 leng=242176 end=0xc00000001eb05190)

A >> Shm MMDAT area (addr=0xc00000001eb06000 leng=15499264 end=0xc00000001f9ce000)

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 47822 bytes at 0xc000000006cdc000

N SsfSapSecin: putenv(SECUDIR=/usr/sap/AWP/D02/sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is /usr/sap/AWP/D02/exe/libsapsecu.so .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...completed with return code 5.

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ipl_Init(): wp task type is 5:SPO, skip initialization

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

S

S Thu Oct 16 20:19:04 2008

S found spool memory service RSPO-ACTIONS at 0xc00000013fdd0630

S catch mode for rspo_rperf disabled

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

M rdisp/cpic_snc_delete2: -1 -> 0

M rdisp/cpic_snc_delete: -1 -> 0

M

M Thu Oct 16 20:21:52 2008

M ThSetTerminalEnv: gui_from_spool= 1

S datafile pattern is '/usr/sap/AWP/D02/data/++++++++' (checksum 2104)

T new memory block 0x6000000004168970

S select: SETUP(ZINV)

S select: ->0

M SosICreateNewAnchorArray: sos_search_anchor_semantics = 1

S

S Thu Oct 16 20:22:06 2008

S 1 pages (OTF) printed in 14 seconds, avg. 0.0 pages per sec

S Timeinfo 16601 /1 ( DOT ): 14 1 OTF ( 0 0 0 0 0 14 )

S

S Thu Oct 16 20:22:09 2008

S 1 pages (OTF) printed in 3 seconds, avg. 0.3 pages per sec

S Timeinfo 16602 /1 ( DOT ): 3 1 OTF ( 0 0 0 0 0 3 )

S

S Thu Oct 16 20:22:12 2008

S 1 pages (OTF) printed in 2 seconds, avg. 0.5 pages per sec

S Timeinfo 16603 /1 ( DOT ): 2 1 OTF ( 0 0 0 0 0 2 )

S

S Thu Oct 16 20:22:18 2008

S 1 pages (OTF) printed in 2 seconds, avg. 0.5 pages per sec

S Timeinfo 16604 /1 ( DOT ): 2 1 OTF ( 0 0 0 0 0 2 )

S

S Thu Oct 16 20:23:19 2008

S 1 pages (OTF) printed in 14 seconds, avg. 0.0 pages per sec

S Timeinfo 16605 /1 ( DOT ): 14 1 OTF ( 0 0 0 0 0 14 )

S

S Thu Oct 16 20:24:06 2008

S 1 pages (OTF) printed in 2 seconds, avg. 0.5 pages per sec

S Timeinfo 16606 /1 ( DOT ): 2 1 OTF ( 0 0 0 0 0 2 )

............

**Work Process which remains idle**

*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 02

M sid AWP

M systemid 274 (HP (IA-64) with HP-UX)

M relno 7000

M patchlevel 0

M patchno 159

M intno 20050900

M make: single threaded, Unicode, 64 bit, optimized

M pid 20554

M

M

M Thu Oct 16 20:19:00 2008

M kernel runs with dp version 237000(ext=110000) (@(#) DPLIB-INT-VERSION-237000-UC)

M length of sys_adm_ext is 576 bytes

M

M Thu Oct 16 20:19:02 2008

M ***LOG Q01=> ThInit, WPStart (Workproc20 1 20554) [thxxhead.c 1281]

M ThInit: running on host awpa

M calling db_connect ...

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@AWP on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0x60000000039cf6c0 0x60000000039d7190 0x60000000039e7968

C Attaching to DB Server AWP (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08)

C Starting user session (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08,usrhp=0x60000000039d79a8)

C Now '/@AWP' is connected: con_hdl=0, nls_hdl=0, session_id=210.

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0x60000000039e7898,usrhp=0x60000000039d79a8)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@AWP on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0x60000000039cf6c0 0x60000000039d7190 0x60000000039e7968

C Starting user session (con_hdl=0,svchp=0x60000000039e7898,srvhp=0x60000000039e9c08,usrhp=0x60000000039d79a8)

C Now 'SAPSR3/<pwd>@AWP' is connected: con_hdl=0, nls_hdl=0, session_id=210.

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance AWP is running on awpd with ORACLE version 10.2.0.2.0 since OCT 16, 2008, 20:15:09

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20081016 201902 awpd

C build_stmt: reallocating stmt buffer: 256 -> 2000 characters

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip

I MtxInit: 20 0 0

M SHM_PRES_BUF (addr: 0xc000000128000000, size: 20000000)

M SHM_ROLL_AREA (addr: 0xc00000012a000000, size: 134217728)

M SHM_PAGING_AREA (addr: 0xc000000132000000, size: 134217728)

M SHM_ROLL_ADM (addr: 0xc00000000a975000, size: 2672386)

M SHM_PAGING_ADM (addr: 0xc000000006d00000, size: 656416)

M ThCreateNoBuffer allocated 560152 bytes for 1000 entries at 0xc00000013a002000

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12176 bytes (50 server) at 0xc000000006cb7000

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 20 initializing ....

X Using implementation std

X <ES> Info: use normal pages (no huge table support available)

X ES initialized.

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 0xc00000013a08c090, size: 576)

B dbntab: Buffer FTAB(anchor array) (addr: 0xc00000013a08c2d0, size: 480104)

B dbntab: Buffer FTAB(item array) (addr: 0xc00000013a101640, size: 1920000)

B dbntab: Buffer FTAB(data area) (addr: 0xc00000013a2d6240, size: 61440000)

B dbntab: Buffer IREC(hash header) (addr: 0xc00000013dd70090, size: 576)

B dbntab: Buffer IREC(anchor array) (addr: 0xc00000013dd702d0, size: 480104)

B dbntab: Buffer IREC(item array) (addr: 0xc00000013dde5640, size: 480000)

B dbntab: Buffer IREC(data area) (addr: 0xc00000013de5a940, size: 8192000)

B dbntab: Buffer STAB(hash header) (addr: 0xc00000013e62c090, size: 576)

B dbntab: Buffer STAB(anchor array) (addr: 0xc00000013e62c2d0, size: 480104)

B dbntab: Buffer STAB(item array) (addr: 0xc00000013e6a1640, size: 480000)

B dbntab: Buffer STAB(data area) (addr: 0xc00000013e716940, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 0xc00000013ea06090, size: 2976)

B dbntab: Buffer TTAB(anchor array) (addr: 0xc00000013ea06c30, size: 480104)

B dbntab: Buffer TTAB(item array) (addr: 0xc00000013ea7bfa0, size: 1200000)

B dbntab: Buffer TTAB(data area) (addr: 0xc00000013eba0f20, size: 8760000)

B db_con_shm_ini: WP_ID = 20, WP_CNT = 23, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 0xc000000144011420)

B dbtbxbuf: Buffer TABL (addr: 0xc000000147000110, size: 100000000, end: 0xc00000014cf5e210)

B dbtbxbuf: Buffer TABLP (addr: 0xc00000014d000110, size: 61440000, end: 0xc000000150a98110)

B dbexpbuf: Buffer EIBUF (addr: 0xc000000151000120, size: 40960000, end: 0xc000000153710120)

B dbexpbuf: Buffer ESM (addr: 0xc00000001d800120, size: 4194304, end: 0xc00000001dc00120)

B dbexpbuf: Buffer CUA (addr: 0xc00000013f401120, size: 10240000, end: 0xc00000013fdc5120)

B dbexpbuf: Buffer OTR (addr: 0xc000000127800120, size: 4194304, end: 0xc000000127c00120)

B dbcalbuf: Buffer CALE (addr: 0xc00000000ac03000, size: 500000, end: 0xc00000000ac7d120)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 0x6000000003cdec90

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 2 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 0xc00000013fdc6080

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 0xc00000013fdc68e0

S using messages for server info

S size of spec char cache entry: 297032 bytes (timeout 100 sec)

S size of open spool request entry: 2272 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A PXA

A PXA IN ITIALIZATION

A

A Thu Oct 16 20:19:03 2008

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 15608kb, dir_size: 15516kb.

A Attached to PXA (address 0xc000000154000000, size 400000K)

A abap/pxa = shared unprotect gen_remote

A PXA INITIALIZATION FINISHED

A PXA

A

A ABAP ShmAdm attached (addr=0xc00000001e5d2000 leng=20955136 end=0xc00000001f9ce000)

A >> Shm MMADM area (addr=0xc00000001eac9f90 leng=242176 end=0xc00000001eb05190)

A >> Shm MMDAT area (addr=0xc00000001eb06000 leng=15499264 end=0xc00000001f9ce000)

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 47822 bytes at 0xc000000006cdc000

N SsfSapSecin: putenv(SECUDIR=/usr/sap/AWP/D02/sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is /usr/sap/AWP/D02/exe/libsapsecu.so .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...completed with return code 5.

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ipl_Init(): wp task type is 5:SPO, skip initialization

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

S using action cache size 20 (prof=20)

S creating spool memory service RSPO-ACTIONS at 0xc00000013fdd0630

S

S Thu Oct 16 20:19:04 2008

S catch mode for rspo_rperf disabled

M rdisp/cpic_snc_delete2: -1 -> 0

M rdisp/cpic_snc_delete: -1 -> 0

T

T Thu Oct 16 20:26:22 2008

T new memory block 0x6000000004202ae0

Former Member
0 Kudos

Do you have Op modes setup? .. and if so, have you added the additional spool process?

Former Member
0 Kudos

can you please paste both spool work process log files?

cheers,

-Sunil