"Unknown result table" when used with hibernate

[Former Member]

When using sapdb with hibernate, we get under some circumstances a "unknown result table error". Using jdbc-trace this seems to be a database-problem and not a hibernate problem- As you can see in the trace, there is a column "cost_center.id" that is aliased to "id171_0_". A "com.sap.dbtech.jdbc.ResultSetSapDB at dfc719b.getLong (id171_0_)" produces the error.

Using database-studio we can execute the select without any problem. Additional info is found here: http://jira.lacho.net/jira/browse/ES-579 and here: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3599

com.sap.dbtech.jdbc.ConnectionSapDB at e7587b2[T316].prepareStatement (select costcenter0_.user_assignment_id as user1_10_, costcenter0_.cost_center_id as cost2_10_, costcenter1_.id as id171_0_, costc

enter1_.accountNumber as accountN2_171_0_, costcenter1_.balance as balance171_0_, costcenter1_.balance_currency as balance4_171_0_, costcenter1_.budget as budget171_0_, costcenter1_.budget_currency

as budget6_171_0_, costcenter1_.budgetExcessAllowed as budgetEx7_171_0_, costcenter1_.bdg_extra as bdg8_171_0_, costcenter1_.bdg_extra_currency as bdg9_171_0_, costcenter1_.budgetPeriod as budgetP

10_171_0_, costcenter1_.customer_id as customer13_171_0_, costcenter1_.manager_id as manager14_171_0_, costcenter1_.name as name171_0_, costcenter1_.transferBudget as transfe12_171_0_, customer2_.i

d as id169_1_, customer2_.accountId as accountId169_1_, customer2_.addr_id as addr16_169_1_, customer2_.attribute01 as attribute3_169_1_, customer2_.attribute02 as attribute4_169_1_, customer2_.att

ribute03 as attribute5_169_1_, customer2_.attribute04 as attribute6_169_1_, customer2_.attribute05 as attribute7_169_1_, customer2_.attribute06 as attribute8_169_1_, customer2_.attribute07 as attri

bute9_169_1_, customer2_.attribute08 as attribute10_169_1_, customer2_.attribute09 as attribute11_169_1_, customer2_.attribute10 as attribute12_169_1_, customer2_.delivery_lock_id as delivery17_169

1, customer2_.externalAccountId1 as externa13_169_1_, customer2_.externalAccountId2 as externa14_169_1_, customer2_.owner_id as owner18_169_1_, customer2_.pricelist_id as pricelist19_169_1_, cust

omer2_.pricingSchemaName as pricing15_169_1_, address3_.id as id167_2_, address3_.city as city167_2_, address3_.country_id as country16_167_2_, address3_.fax as fax167_2_, address3_.fon as fon167_2

, address3.houseNumber as houseNum5_167_2_, address3_.mail as mail167_2_, address3_.name1 as name7_167_2_, address3_.name2 as name8_167_2_, address3_.name3 as name9_167_2_, address3_.name4 as nam

e10_167_2_, address3_.postbox as postbox167_2_, address3_.postcode as postcode167_2_, address3_.postcodeCompany as postcod13_167_2_, address3_.postcodePostbox as postcod14_167_2_, address3_.street

as street167_2_, address3_.title_id as title17_167_2_, country4_.id as id161_3_, country4_.isoCode as isoCode161_3_, country4_.name as name161_3_, title5_.id as id165_4_, title5_.isOrganization as

isOrgani2_165_4_, title5_.name as name165_4_, deliverylo6_.id as id193_5_, deliverylo6_.autoDeliveryLock as autoDeli2_193_5_, deliverylo6_.description as descript3_193_5_, deliverylo6_.messageLock

as messageL4_193_5_, deliverylo6_.name as name193_5_, deliverylo6_.orderLock as orderLock193_5_, deliverylo6_.reservationLock as reservat7_193_5_, pricelistt7_.id as id177_6_, pricelistt7_.descript

ion as descript2_177_6_, pricelistt7_.name as name177_6_, contact8_.id as id168_7_, contact8_.customer_id as customer12_168_7_, contact8_.firstName as firstName168_7_, contact8_.ignoreAssortment as

ignoreAs3_168_7_, contact8_.lastName as lastName168_7_, contact8_.officeFax as officeFax168_7_, contact8_.officeMail as officeMail168_7_, contact8_.officeMobile as officeMo7_168_7_, contact8_.offi

cePhone as officePh8_168_7_, contact8_.role as role168_7_, contact8_.title_id as title13_168_7_, contact8_.webPassword as webPass10_168_7_, contact8_.webUserName as webUser11_168_7_, customer9_.id

as id169_8_, customer9_.accountId as accountId169_8_, customer9_.addr_id as addr16_169_8_, customer9_.attribute01 as attribute3_169_8_, customer9_.attribute02 as attribute4_169_8_, customer9_.attri

bute03 as attribute5_169_8_, customer9_.attribute04 as attribute6_169_8_, customer9_.attribute05 as attribute7_169_8_, customer9_.attribute06 as attribute8_169_8_, customer9_.attribute07 as attribu

te9_169_8_, customer9_.attribute08 as attribute10_169_8_, customer9_.attribute09 as attribute11_169_8_, customer9_.attribute10 as attribute12_169_8_, customer9_.delivery_lock_id as delivery17_169_8

, customer9.externalAccountId1 as externa13_169_8_, customer9_.externalAccountId2 as externa14_169_8_, customer9_.owner_id as owner18_169_8_, customer9_.pricelist_id as pricelist19_169_8_, custom

er9_.pricingSchemaName as pricing15_169_8_, title10_.id as id165_9_, title10_.isOrganization as isOrgani2_165_9_, title10_.name as name165_9_ from j_cc_user2user costcenter0_, cost_center costcente

r1_, KNA1 customer2_, ADDR address3_, C005 country4_, CSAD3 title5_, delivery_lock deliverylo6_, sd_pr_prltype pricelistt7_, KNVK contact8_, KNA1 customer9_, CSAD3 title10_ where costcenter0_.cost_

center_id=costcenter1_.id() and costcenter1_.customer_id=customer2_.id() and customer2_.addr_id=address3_.id() and address3_.country_id=country4_.id() and address3_.title_id=title5_.id(+) and c

ustomer2_.delivery_lock_id=deliverylo6_.id() and customer2_.pricelist_id=pricelistt7_.id() and costcenter1_.manager_id=contact8_.id() and contact8_.customer_id=customer9_.id() and contact8_.tit

le_id=title10_.id(+) and costcenter0_.user_assignment_id=?)

=> com.sap.dbtech.jdbc.CallableStatementSapDB at 564ca930[T316][ParseID 0025a3c60000340254002c00]

com.sap.dbtech.jdbc.CallableStatementSapDB at 564ca930[T316][ParseID 0025a3c60000340254002c00].setQueryTimeout (60)

com.sap.dbtech.jdbc.CallableStatementSapDB at 564ca930[T316][ParseID 0025a3c60000340254002c00].setLong (1, 312250)

com.sap.dbtech.jdbc.CallableStatementSapDB at 564ca930[T316][ParseID 0025a3c60000340254002c00].executeQuery ()

=> com.sap.dbtech.jdbc.ResultSetSapDB at 7dfc719b

com.sap.dbtech.jdbc.ResultSetSapDB at 7dfc719b.next ()

=> true

com.sap.dbtech.jdbc.ResultSetSapDB at 7dfc719b.getLong (id171_0_)

<-!

Timestamp: 2008-11-12 12:26:50.808com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4000] (at 10): Unknown result table

[Former Member · Accepted solution]

Hallo,

after checking all info, vtrace, statement and parameter, I would recommend a workaround.

Change parameter USESELECTFETCH to NO and the -4000 should not occur any more.

In the meantime we will try to figure out why some info wanted by the client is not provided by the kernel in this version, with special kind of statements ...

Hope, the workaround will help.

Elke

[Former Member · Accepted solution]

Hi Elke,

the workaround works.

Is sapdb 7.7 worth a try regarding this problem or will i face it there also?

Many thanks for your help,

Dirk

[Former Member]

stop, please stop sending knldiag.

I asked for the trace, where these lines with REQUETS: RECEIVE: b02 b07 can be found in

Elke

[Former Member]

Hi Elke,

the posts before (kerneldump) are the parameters lars asked for.

[Former Member]

Hi,

we would like to see a little bit more.

If it is possible as it was in November, please provide a link to the whole trace (where you sent the last lines of).

And if possible please provide the full statement resulting in this error as we will only see the bginning of it in the trace.

Thank you in advance.

Elke

[Former Member]

Hi Elke,

the whole trace can be found here:

http://jira.lacho.net/jira/secure/attachment/10318/knltrace-s102-20081112.txt

The statement resulting in the error can be found here:

http://jira.lacho.net/jira/browse/ES-579?focusedCommentId=10725#action_10725

Thanks,

Dirk

[lbreddemann]

Hi Dirk,

what is the version of MaxDB you're using here?

What is the version of the JDBC driver?

Can you produce a vtrace of this problem as described here [MaxDB database trace|https://wiki.sdn.sap.com/wiki/x/2yg] ?

Is SharedSQL activated for this database or not?

regards,

Lars

[Former Member]

Hi Lars,

versions are:

MaxDB 7.6.05.09

Driver sapdbc-7.6.05_006-000-008-153

SharedSQL is activated.

The vtrace is quite huge (about 19.000 lines) so i can't save it as a text-file from database studio. If the generated knltrace.dat is ok you can find it here (relevant information seems to start in line 2093):

http://www.lacho.net/tmp/knltrace.dat.bin

regards,

Dirk

[Former Member]

Hi Lars,

can i do anything to help you in investigating the problem? Do you need any additional information?

Would turning of sharedSQL help solving the problem or will i get performance penalties?

regards,

Dirk

[lbreddemann]

Hi Dirk,

sorry, I had no time yet to look into this.

regards,

Lars

[lbreddemann]

Hi Dirk,

I cannot read the file since my MaxDB version differs.

Please generate the trace protocol (e.g. via DBMGUI) and provide a zipped version for download.

thanks

Lars

[Former Member]

Hi Lars,

i've found no way to extract the whole trace from database studio. Here are the last 1000 or so lines. Nope, can post only 15000 chars. If you need more, please let me know. I will then try to copy the trace in chunks:

18684:  >AccessOp Close() TabNo 008
18685:  >AccessOp Close() TabNo 007
18686:  >AccessOp Close() TabNo 005
18687:  >AccessOp Close() TabNo 004
18688:  >AccessOp Close() TabNo 003
18689:  >AccessOp Close() TabNo 002
18690:  >AccessOp Close() TabNo 001
18691:   AccessOp idnil/17665 return_result TabNo 011
18692:   AccessOp idnil/17665 return_result TabNo 010
18693:   AccessOp idnil/17665 return_result TabNo 009
18694:   AccessOp idnil/17665 return_result TabNo 008
18695:   AccessOp idnil/17665 return_result TabNo 007
18696:   AccessOp idnil/17665 return_result TabNo 006
18697:   AccessOp idnil/17665 return_result TabNo 005
18698:   AccessOp idnil/17665 return_result TabNo 004
18699:   AccessOp idnil/17665 return_result TabNo 003
18700:   AccessOp idnil/17665 return_result TabNo 002
18701:   AccessOp idnil/17665 return_result TabNo 001
18702:   KB05 idnil/17665 return_result
18703:  >b07cnext zero key
18704:   b07cnext root               74904; *** buffer_limit ***
18705:  >b07cnext leaf               45398; index 0
18706:   b07cnext root               74904; *** buffer_limit ***
18707:  >b07cnext leaf                 432; index 0
18708:   b07cnext root               74904; *** buffer_limit ***
18709:  >b07cnext leaf               76073; index 0
18710:   b07cnext root               74904; ok
18711:  >KB05 idnil/17665 unlock first
18712:   KB05 idnil/17665 ok
18713:  >b07cget key(138):
18714:           00000000 00000000 00B54A44 42435F43 5552534F 525F3733 30202020
18715:           20202020 20202020 20202020 20202020 20202020 20202020 20202020
18716:           20202020
18717:           '..........JDBC_CURSOR_730                                   '
18718:   b07cget root                59826; *** key_not_found ***
18719:  RECEIVE: ascii, normal_swap, 70400-ODB     (2 segments, len: 129520)
18720:  (79.2354  page 80)
18721:     ok / RETURN SEGMENT 1   (3 parts, len: 129432)
18722:           select_fc, sqlstate: '00000'
18723:           internal WARNING   0: resultset_closed
18724:     data LAST PART   (40 arguments, size: 130856)
18725:           buf(129320):
18726:           00C63122 50000000 00000000 00C63122 40000000 00000000 00C63122
18727:           40000000 00000000 FF000000 00000000 00000000 00000000 00000000
18728:           0000C550 00000000 00000000 00204555 52202020 20202020 20202020
18729:           20202020 20202020 20202020 20202020 20202020 20202020 20202020
18730:           20202020
18731:           '..1"P.........1"@.........1"@..............................P.'
18732:           '........ EUR                                           '
18733:     resultcount PART   (1 argument, size: 1520)
18734:           result_count: 40
18735:     resulttablename PART   (1 argument, size: 1496)
18736:           buf(15): 'JDBC_CURSOR_730'
18737:     *** -1114 / RETURN SEGMENT 2   (1 part, len: 88, segm_offset: 129432)
18738:           describe_fc, errpos: 1, sqlstate: 'I1114'
18739:     errortext PART   (1 argument, size: 1424, segm_offset: 129432)
18740:           buf(30): 'Communication packet too small'
18741:   
18742:  REQUEST: ascii, normal_swap, 70400-ODB     (1 segment, len: 88)
18743:  (79.2846  page 80)
18744:     dbs SEGMENT 1   (1 part, len: 88)
18745:           session_sqlmode, user_cmd
18746:     command PART   (1 argument, size: 130872)
18747:           buf(26): 'DESCRIBE "JDBC_CURSOR_730"'
18748:  >b07cget key(138):
18749:           00000000 00000000 00B54A44 42435F43 5552534F 525F3733 30202020
18750:           20202020 20202020 20202020 20202020 20202020 20202020 20202020
18751:           20202020
18752:           '..........JDBC_CURSOR_730                                   '
18753:   b07cget root                59826; *** key_not_found ***
18754:  RECEIVE: ascii, normal_swap, 70400-ODB     (1 segment, len: 80)
18755:  (79.3134  page 80)
18756:     *** -4000 / RETURN SEGMENT 1   (1 part, len: 80)
18757:           describe_fc, errpos: 10, sqlstate: '24000'
18758:     errortext PART   (1 argument, size: 130856)
18759:           buf(20): 'Unknown result table'

[lbreddemann]

>

> i've found no way to extract the whole trace from database studio. Here are the last 1000 or so lines. Nope, can post only 15000 chars. If you need more, please let me know. I will then try to copy the trace in chunks:
> 18733:     resultcount PART   (1 argument, size: 1520)
> 18734:           result_count: 40
> 18735:     resulttablename PART   (1 argument, size: 1496)
> 18736:           buf(15): 'JDBC_CURSOR_730'
> 18737:     *** -1114 / RETURN SEGMENT 2   (1 part, len: 88, segm_offset: 129432)
> 18738:           describe_fc, errpos: 1, sqlstate: 'I1114'
> 18739:     errortext PART   (1 argument, size: 1424, segm_offset: 129432)
> 18740:           buf(30): 'Communication packet too small'
> 18741:   
> 18742:  REQUEST: ascii, normal_swap, 70400-ODB     (1 segment, len: 88)
> 18743:  (79.2846  page 80)
> 18744:     dbs SEGMENT 1   (1 part, len: 88)
> 18745:           session_sqlmode, user_cmd
> 18746:     command PART   (1 argument, size: 130872)
> 18747:           buf(26): 'DESCRIBE "JDBC_CURSOR_730"'
> 18748:  >b07cget key(138):
> 18749:           00000000 00000000 00B54A44 42435F43 5552534F 525F3733 30202020
> 18750:           20202020 20202020 20202020 20202020 20202020 20202020 20202020
> 18751:           20202020
> 18752:           '..........JDBC_CURSOR_730                                   '
> 18753:   b07cget root                59826; *** key_not_found ***
> 18754:  RECEIVE: ascii, normal_swap, 70400-ODB     (1 segment, len: 80)
> 18755:  (79.3134  page 80)
> 18756:     *** -4000 / RETURN SEGMENT 1   (1 part, len: 80)
> 18757:           describe_fc, errpos: 10, sqlstate: '24000'
> 18758:     errortext PART   (1 argument, size: 130856)
> 18759:           buf(20): 'Unknown result table'

Ok, these last line should be enough for now.

It looks like the issue is the -1114 'Communication packet too small' error for cursor "JDBC_CURSOR_730". The error does not seem to get handled correctly here, so the next step (describe the cursor) fails, since this cursor is already gone.

Please post the parameter setting of this db instance.

regards,

Lars

[Former Member]

Part 1:

22 2009-02-10 11:26:49 23671 20234 RTE Dump of all kernel parameters start

23 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 1

24 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 2

25 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 3

26 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 4

27 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 5

28 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 6

29 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 7

30 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 8

31 2009-02-10 11:26:49 23671 20207 RTE Using mode NORMAL for data volume 9

32 2009-02-10 11:26:49 23671 20235 RTE ADMIN=1

33 2009-02-10 11:26:49 23671 20235 RTE AKDUMP_ALLOWED=YES

34 2009-02-10 11:26:49 23671 20235 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO

35 2009-02-10 11:26:49 23671 20235 RTE AUTHENTICATION_ALLOW=

36 2009-02-10 11:26:49 23671 20235 RTE AUTHENTICATION_DENY=

37 2009-02-10 11:26:49 23671 20235 RTE AUTOSAVE=1

38 2009-02-10 11:26:49 23671 20235 RTE AUTO_RECREATE_BAD_INDEXES=NO

39 2009-02-10 11:26:49 23671 20235 RTE BACKUPRESULT=1

40 2009-02-10 11:26:49 23671 20235 RTE BACKUP_BLOCK_CNT=64

41 2009-02-10 11:26:49 23671 20235 RTE BACKUPHISTFILE=dbm.knl

42 2009-02-10 11:26:49 23671 20235 RTE BACKUPMED_DEF=dbm.mdf

43 2009-02-10 11:26:49 23671 20235 RTE CACHE_IN_SHARED_MEMORY=NO

44 2009-02-10 11:26:49 23671 20235 RTE CACHE_SIZE=64000

45 2009-02-10 11:26:49 23671 20235 RTE CALLSTACKLEVEL=0

46 2009-02-10 11:26:49 23671 20235 RTE CATCACHE_MINSIZE=262144

47 2009-02-10 11:26:49 23671 20235 RTE CAT_CACHE_SUPPLY=25664

48 2009-02-10 11:26:49 23671 20235 RTE CHECKDATA=1

49 2009-02-10 11:26:49 23671 20235 RTE CHECK_BACKUP=NO

50 2009-02-10 11:26:49 23671 20235 RTE CHECK_COMMON=0

51 2009-02-10 11:26:49 23671 20235 RTE CHECK_CONVERTER=0

52 2009-02-10 11:26:49 23671 20235 RTE CHECK_DATACACHE=NO

53 2009-02-10 11:26:49 23671 20235 RTE CHECK_DATAINDEX=0

54 2009-02-10 11:26:49 23671 20235 RTE CHECK_DATAPAGELOG=0

55 2009-02-10 11:26:49 23671 20235 RTE CHECK_FBM=0

56 2009-02-10 11:26:49 23671 20235 RTE CHECK_HASHED_RESULTSET=0

57 2009-02-10 11:26:49 23671 20235 RTE CHECK_IOMAN=0

58 2009-02-10 11:26:49 23671 20235 RTE CHECK_KB_REGIONS=NO

59 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOCK_SUPPLY=NO

60 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOCK=NO

61 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOGHISTORY=0

62 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOGPAGE=0

63 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOGTRANS=0

64 2009-02-10 11:26:49 23671 20235 RTE CHECK_LOGVOLUME=0

65 2009-02-10 11:26:49 23671 20235 RTE CHECK_QUERYREWRITE=0

66 2009-02-10 11:26:49 23671 20235 RTE CHECK_REGIONS=NO

67 2009-02-10 11:26:49 23671 20235 RTE CHECK_SRVTASKS=0

68 2009-02-10 11:26:49 23671 20235 RTE CHECK_TABLE_WIDTH=NO

69 2009-02-10 11:26:49 23671 20235 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO

70 2009-02-10 11:26:49 23671 20235 RTE CHECK_TRANSLIST=NO

71 2009-02-10 11:26:49 23671 20235 RTE CHECK_TREE_LOCKS=NO

72 2009-02-10 11:26:49 23671 20235 RTE CHECK_TREE=NO

73 2009-02-10 11:26:49 23671 20235 RTE CLUSTERCOMPRESSIONFILLTHRESHOLD=10

74 2009-02-10 11:26:49 23671 20235 RTE CLUSTERCOMPRESSIONTHRESHOLD=1000

75 2009-02-10 11:26:49 23671 20235 RTE CLUSTERED_LOBS=NO

76 2009-02-10 11:26:49 23671 20235 RTE CLUSTER_WRITE_THRESHOLD=80

77 2009-02-10 11:26:49 23671 20235 RTE COLUMNCOMPRESSION=YES

78 2009-02-10 11:26:49 23671 20235 RTE _COMMENT=

79 2009-02-10 11:26:49 23671 20235 RTE CONTROLPASSWORD=***

80 2009-02-10 11:26:49 23671 20235 RTE CONTROLUSERID=DBM

81 2009-02-10 11:26:49 23671 20235 RTE CONVERTER_REGIONS=8

82 2009-02-10 11:26:49 23671 20235 RTE DATABASEFULL=1

83 2009-02-10 11:26:49 23671 20235 RTE DATACACHE_RGNS=32

84 2009-02-10 11:26:49 23671 20235 RTE DATA_IO_BLOCK_COUNT=64

85 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_GROUPS=1

86 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0001=NORMAL

87 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0002=NORMAL

88 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0003=NORMAL

89 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0004=NORMAL

90 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0005=NORMAL

91 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0006=NORMAL

92 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0007=NORMAL

93 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0008=NORMAL

94 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_MODE_0009=NORMAL

95 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0001=DAT_0001

96 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0002=DAT_0002

97 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0003=DAT_0003

98 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0004=/volume1/SHOP3_01/DAT_0004

99 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0005=/volume1/SHOP3_01/DAT_0005

100 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0006=/volume1/SHOP3_01/DAT_0006

101 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0007=/volume1/SHOP3_01/DAT_0007

102 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0008=/volume1/SHOP3_01/DAT_0008

103 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_NAME_0009=/volume1/SHOP3_01/DAT_0009

104 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0001=262144

105 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0002=262144

106 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0003=262144

107 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0004=262144

108 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0005=262144

109 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0006=131072

110 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0007=262144

111 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0008=262144

112 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_SIZE_0009=262144

113 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0001=F

114 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0002=F

115 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0003=F

116 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0004=F

117 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0005=F

118 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0006=F

119 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0007=F

120 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0008=F

121 2009-02-10 11:26:49 23671 20235 RTE DATA_VOLUME_TYPE_0009=F

[Former Member]

Part 2:

122 2009-02-10 11:26:49 23671 20235 RTE DATE_TIME_FORMAT=INTERNAL

123 2009-02-10 11:26:49 23671 20235 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H

124 2009-02-10 11:26:49 23671 20235 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L

125 2009-02-10 11:26:49 23671 20235 RTE DDLTRIGGER=YES

126 2009-02-10 11:26:49 23671 20235 RTE DEADLOCK_DETECTION=4

127 2009-02-10 11:26:49 23671 20235 RTE DEADLOCK_DUMP_FILENAME=

128 2009-02-10 11:26:49 23671 20235 RTE DEFAULT_CODE=ASCII

129 2009-02-10 11:26:49 23671 20235 RTE DELAYCOMMIT=NO

130 2009-02-10 11:26:49 23671 20235 RTE DELAYLOGWRITER=0

131 2009-02-10 11:26:49 23671 20235 RTE DIAG_HISTORY_NUM=2

132 2009-02-10 11:26:49 23671 20235 RTE DIAG_HISTORY_PATH=/var/opt/sdb/data/wrk/SHOP3_01/DIAGHISTORY

133 2009-02-10 11:26:49 23671 20235 RTE DIAGSEM=0

134 2009-02-10 11:26:49 23671 20235 RTE DWIO_AREA_FLUSH=50

135 2009-02-10 11:26:49 23671 20235 RTE DWIO_AREA_SIZE=50

136 2009-02-10 11:26:49 23671 20235 RTE DWLRU_TAIL_FLUSH=25

137 2009-02-10 11:26:49 23671 20235 RTE DYNTASK_STACK=NO

138 2009-02-10 11:26:49 23671 20235 RTE ENABLE_CHECK_INSTANCE=YES

139 2009-02-10 11:26:49 23671 20235 RTE ENABLE_SYSTEM_TRIGGERS=YES

140 2009-02-10 11:26:49 23671 20235 RTE ERROR=3

141 2009-02-10 11:26:49 23671 20235 RTE _EVENTFILE=knldiag.evt

142 2009-02-10 11:26:49 23671 20235 RTE _EVENTSIZE=0

143 2009-02-10 11:26:49 23671 20235 RTE EVENT=1

144 2009-02-10 11:26:49 23671 20235 RTE EXPAND_COM_TRACE=NO

145 2009-02-10 11:26:49 23671 20235 RTE EXTERNAL_DUMP_REQUEST=NO

146 2009-02-10 11:26:49 23671 20235 RTE FBM_CLUSTER_MODE=MIXED

147 2009-02-10 11:26:49 23671 20235 RTE FBMLOW_IO_RATE=10

148 2009-02-10 11:26:49 23671 20235 RTE FBM_VOLUME_BALANCE=10

149 2009-02-10 11:26:49 23671 20235 RTE FBM_VOLUME_COMPRESSION=50

150 2009-02-10 11:26:49 23671 20235 RTE FILEDIR_SPINLOCKPOOL_SIZE=10

151 2009-02-10 11:26:49 23671 20235 RTE FORBID_LOAD_BALANCING=YES

152 2009-02-10 11:26:49 23671 20235 RTE FORMATTING_MODE=PARALLEL

153 2009-02-10 11:26:49 23671 20235 RTE FORMAT_DATAVOLUME=YES

154 2009-02-10 11:26:49 23671 20235 RTE HASHED_RESULTSET_CACHESIZE=262144

155 2009-02-10 11:26:49 23671 20235 RTE HASHED_RESULTSET=YES

156 2009-02-10 11:26:49 23671 20235 RTE HEAP_CHECK_LEVEL=0

157 2009-02-10 11:26:49 23671 20235 RTE HIRES_TIMER_TYPE=CPU

158 2009-02-10 11:26:49 23671 20235 RTE HS_STORAGE_DLL=libhsscopy

159 2009-02-10 11:26:49 23671 20235 RTE HS_SYNC_INTERVAL=50

160 2009-02-10 11:26:49 23671 20235 RTE IDXFILELIST_SIZE=2048

161 2009-02-10 11:26:49 23671 20235 RTE INDEX_LEAF_CACHING=2

162 2009-02-10 11:26:49 23671 20235 RTE INIT_ALLOCATORSIZE=258048

163 2009-02-10 11:26:49 23671 20235 RTE INSTANCE_TYPE=OLTP

164 2009-02-10 11:26:49 23671 20235 RTE IOPROCSFOR_PRIO=0

165 2009-02-10 11:26:49 23671 20235 RTE IOPROCSFOR_READER=0

166 2009-02-10 11:26:49 23671 20235 RTE IOPROCSPER_DEV=2

167 2009-02-10 11:26:49 23671 20235 RTE IOPROCSSWITCH=2

168 2009-02-10 11:26:49 23671 20235 RTE JOIN_MAXTAB_LEVEL4=16

169 2009-02-10 11:26:49 23671 20235 RTE JOIN_MAXTAB_LEVEL9=5

170 2009-02-10 11:26:49 23671 20235 RTE JOIN_SEARCH_LEVEL=0

171 2009-02-10 11:26:49 23671 20235 RTE JOIN_TABLEBUFFER=128

172 2009-02-10 11:26:49 23671 20235 RTE _KERNELDIAGFILE=knldiag

173 2009-02-10 11:26:49 23671 20235 RTE KERNELDIAGSIZE=800

174 2009-02-10 11:26:49 23671 20235 RTE _KERNELDUMPFILE=knldump

175 2009-02-10 11:26:49 23671 20235 RTE _KERNELTRACEFILE=knltrace

176 2009-02-10 11:26:49 23671 20235 RTE KERNELTRACESIZE=4363

177 2009-02-10 11:26:49 23671 20235 RTE KERNELVERSION=KERNEL 7.6.05 BUILD 009-123-191-997

178 2009-02-10 11:26:49 23671 20235 RTE LMLOCK_REGIONS=0

179 2009-02-10 11:26:49 23671 20235 RTE LMREQUEST_REGIONS=0

180 2009-02-10 11:26:49 23671 20235 RTE LMTRANS_REGIONS=0

181 2009-02-10 11:26:49 23671 20235 RTE LOAD_BALANCING_CHK=0

182 2009-02-10 11:26:49 23671 20235 RTE LOAD_BALANCING_DIF=10

183 2009-02-10 11:26:49 23671 20235 RTE LOAD_BALANCING_EQ=5

184 2009-02-10 11:26:49 23671 20235 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0

185 2009-02-10 11:26:49 23671 20235 RTE LOCKMANAGERENABLED=NO

186 2009-02-10 11:26:49 23671 20235 RTE LOCKSUPPLY_BLOCK=100

187 2009-02-10 11:26:49 23671 20235 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H

188 2009-02-10 11:26:49 23671 20235 RTE LOGFULL=1

189 2009-02-10 11:26:49 23671 20235 RTE LOGSEGMENTFULL=1

190 2009-02-10 11:26:49 23671 20235 RTE LOG_BACKUP_TO_PIPE=NO

191 2009-02-10 11:26:49 23671 20235 RTE LOG_IO_BLOCK_COUNT=8

192 2009-02-10 11:26:49 23671 20235 RTE LOG_IO_QUEUE=50

193 2009-02-10 11:26:49 23671 20235 RTE LOG_MIRRORED=NO

194 2009-02-10 11:26:49 23671 20235 RTE LOG_QUEUE_COUNT=1

195 2009-02-10 11:26:49 23671 20235 RTE LOG_SEGMENT_SIZE=853

196 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_NAME_001=LOG_001

197 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_NAME_002=LOG_002

198 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_NAME_003=LOG_003

199 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_NAME_004=LOG_004

200 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_SIZE_001=2560

201 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_SIZE_002=2560

202 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_SIZE_003=2560

203 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_SIZE_004=2560

204 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_TYPE_001=F

205 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_TYPE_002=F

206 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_TYPE_003=F

207 2009-02-10 11:26:49 23671 20235 RTE LOG_VOLUME_TYPE_004=F

208 2009-02-10 11:26:49 23671 20235 RTE LRU_FOR_SCAN=NO

209 2009-02-10 11:26:49 23671 20235 RTE MAXBACKUPDEVS=2

210 2009-02-10 11:26:49 23671 20235 RTE MAXCPU=1

211 2009-02-10 11:26:49 23671 20235 RTE MAXDATAVOLUMES=20

212 2009-02-10 11:26:49 23671 20235 RTE _MAXEVENTS=100

213 2009-02-10 11:26:49 23671 20235 RTE _MAXEVENTTASKS=2

214 2009-02-10 11:26:49 23671 20235 RTE MAXGARBAGECOLL=1

215 2009-02-10 11:26:49 23671 20235 RTE MAXLOCKS=32080

216 2009-02-10 11:26:49 23671 20235 RTE MAXLOGVOLUMES=5

217 2009-02-10 11:26:49 23671 20235 RTE MAXPAGER=32

218 2009-02-10 11:26:49 23671 20235 RTE MAXRGN_REQUEST=-1

219 2009-02-10 11:26:49 23671 20235 RTE MAXSERVERTASKS=46

220 2009-02-10 11:26:49 23671 20235 RTE MAXTASKSTACK=512

221 2009-02-10 11:26:49 23671 20235 RTE _MAXTRANS=3204

222 2009-02-10 11:26:49 23671 20235 RTE MAXUSERTASKS=400

223 2009-02-10 11:26:49 23671 20235 RTE MAXVOLUMES=26

224 2009-02-10 11:26:49 23671 20235 RTE MAX_HASHTABLE_MEMORY=5120

225 2009-02-10 11:26:49 23671 20235 RTE MAX_LOG_QUEUE_COUNT=0

226 2009-02-10 11:26:49 23671 20235 RTE MAXMESSAGE_FILES=0

227 2009-02-10 11:26:49 23671 20235 RTE MAX_MESSAGE_LIST_LENGTH=100

228 2009-02-10 11:26:49 23671 20235 RTE MAX_RETENTION_TIME=480

229 2009-02-10 11:26:49 23671 20235 RTE MAX_SERVERTASK_STACK=500

230 2009-02-10 11:26:49 23671 20235 RTE MAX_SINGLE_HASHTABLE_SIZE=512

231 2009-02-10 11:26:49 23671 20235 RTE MAX_SPECIALTASK_STACK=500

[Former Member]

Part 3:

232 2009-02-10 11:26:49 23671 20235 RTE MBLOCKDATA_SIZE=32768

233 2009-02-10 11:26:49 23671 20235 RTE MBLOCKQUAL_SIZE=32768

234 2009-02-10 11:26:49 23671 20235 RTE MBLOCKSTACK_SIZE=32768

235 2009-02-10 11:26:49 23671 20235 RTE MBLOCKSTRAT_SIZE=12288

236 2009-02-10 11:26:49 23671 20235 RTE MCOD=NO

237 2009-02-10 11:26:49 23671 20235 RTE MEMORY_ALLOCATION_LIMIT=0

238 2009-02-10 11:26:49 23671 20235 RTE MINREPLYSIZE=4096

239 2009-02-10 11:26:49 23671 20235 RTE MINSERVERTASKS=46

240 2009-02-10 11:26:49 23671 20235 RTE MIN_RETENTION_TIME=60

241 2009-02-10 11:26:49 23671 20235 RTE MONITOR_READ=2147483647

242 2009-02-10 11:26:49 23671 20235 RTE MONITOR_ROWNO=0

243 2009-02-10 11:26:49 23671 20235 RTE MONITOR_SELECTIVITY=0

244 2009-02-10 11:26:49 23671 20235 RTE MONITOR_TIME=2147483647

245 2009-02-10 11:26:49 23671 20235 RTE MPDISP_LOOPS=2

246 2009-02-10 11:26:49 23671 20235 RTE MPDISP_PRIO=DEFAULT

247 2009-02-10 11:26:49 23671 20235 RTE MPRGN_BUSY_WAIT=DEFAULT

248 2009-02-10 11:26:49 23671 20235 RTE MPRGN_DIRTY_READ=DEFAULT

249 2009-02-10 11:26:49 23671 20235 RTE MP_RGN_LOOP=-1

250 2009-02-10 11:26:49 23671 20235 RTE MPRGN_PRIO=DEFAULT

251 2009-02-10 11:26:49 23671 20235 RTE MPRGN_QUEUE=YES

252 2009-02-10 11:26:49 23671 20235 RTE NO_SYNC_TO_DISK_WANTED=NO

253 2009-02-10 11:26:49 23671 20235 RTE OFFICIAL_NODE=

254 2009-02-10 11:26:49 23671 20235 RTE OMS_HEAP_BLOCKSIZE=10000

255 2009-02-10 11:26:49 23671 20235 RTE OMS_HEAP_COUNT=1

256 2009-02-10 11:26:49 23671 20235 RTE OMS_HEAP_LIMIT=0

257 2009-02-10 11:26:49 23671 20235 RTE OMS_HEAP_THRESHOLD=100

258 2009-02-10 11:26:49 23671 20235 RTE OMSREGIONS=0

259 2009-02-10 11:26:49 23671 20235 RTE OMSRGNS=7

260 2009-02-10 11:26:49 23671 20235 RTE OMS_RUN_IN_UDE_SERVER=NO

261 2009-02-10 11:26:49 23671 20235 RTE OMS_STREAM_TIMEOUT=30

262 2009-02-10 11:26:49 23671 20235 RTE OMS_VERS_THRESHOLD=2097152

263 2009-02-10 11:26:49 23671 20235 RTE ONLINE=1

264 2009-02-10 11:26:49 23671 20235 RTE OPMSG1=/dev/console

265 2009-02-10 11:26:49 23671 20235 RTE OPMSG2=/dev/null

266 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_AGGREGATION=YES

267 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_FETCH_REVERSE=YES

268 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_FIRST_ROWS=YES

269 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_HASHTABLE=YES

270 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1

271 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_ONEPHASE=YES

272 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES

273 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_OUTER=YES

274 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000

275 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0

276 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_MIN_MAX=YES

277 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES

278 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_OPERATOR_JOIN=YES

279 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_QUAL_ON_INDEX=YES

280 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_QUERYREWRITE=STATEMENT

281 2009-02-10 11:26:49 23671 20235 RTE OPTIMIZE_STAR_JOIN=YES

282 2009-02-10 11:26:49 23671 20235 RTE OPTIM_CACHE=NO

283 2009-02-10 11:26:49 23671 20235 RTE OPTIM_INV_ONLY=YES

284 2009-02-10 11:26:49 23671 20235 RTE OPTIM_JOIN_FETCH=0

285 2009-02-10 11:26:49 23671 20235 RTE OPTIM_MAX_MERGE=500

286 2009-02-10 11:26:49 23671 20235 RTE OUTOFSESSIONS=3

287 2009-02-10 11:26:49 23671 20235 RTE PACKETSIZE=131072

288 2009-02-10 11:26:49 23671 20235 RTE PAGESIZE=8192

289 2009-02-10 11:26:49 23671 20235 RTE PREALLOCATE_IOWORKER=NO

290 2009-02-10 11:26:49 23671 20235 RTE PRIOBASE_COM=10

291 2009-02-10 11:26:49 23671 20235 RTE PRIOBASE_IOC=80

292 2009-02-10 11:26:49 23671 20235 RTE PRIOBASE_RAV=80

293 2009-02-10 11:26:49 23671 20235 RTE PRIOBASE_REX=40

294 2009-02-10 11:26:49 23671 20235 RTE PRIOBASE_U2U=100

295 2009-02-10 11:26:49 23671 20235 RTE PRIOFACTOR=80

296 2009-02-10 11:26:49 23671 20235 RTE PROTECT_DATACACHE_MEMORY=NO

297 2009-02-10 11:26:49 23671 20235 RTE READAHEADBLOBS=32

298 2009-02-10 11:26:49 23671 20235 RTE READAHEAD_TABLE_THRESHOLD=0

299 2009-02-10 11:26:49 23671 20235 RTE REQUEST_TIMEOUT=5000

300 2009-02-10 11:26:49 23671 20235 RTE RESERVEDSERVERTASKS=25

301 2009-02-10 11:26:49 23671 20235 RTE RESTARTTIME=600

302 2009-02-10 11:26:49 23671 20235 RTE ROW_LOCKS_PER_TRANSACTION=50

303 2009-02-10 11:26:49 23671 20235 RTE ROWRGNS=8

304 2009-02-10 11:26:49 23671 20235 RTE _RTEDUMPFILE=rtedump

305 2009-02-10 11:26:49 23671 20235 RTE RTE_TEST_REGIONS=0

306 2009-02-10 11:26:49 23671 20235 RTE RUNDIRECTORY=/var/opt/sdb/data/wrk/SHOP3_01

307 2009-02-10 11:26:49 23671 20235 RTE SEQUENCE_CACHE=1

308 2009-02-10 11:26:49 23671 20235 RTE SERVERDBFOR_SAP=YES

309 2009-02-10 11:26:49 23671 20235 RTE SESSION_TIMEOUT=120

310 2009-02-10 11:26:49 23671 20235 RTE SET_VOLUME_LOCK=YES

311 2009-02-10 11:26:49 23671 20235 RTE SHAREDSQL_CLEANUPTHRESHOLD=25

312 2009-02-10 11:26:49 23671 20235 RTE SHAREDSQL_COMMANDCACHESIZE=262144

313 2009-02-10 11:26:49 23671 20235 RTE SHAREDSQL=YES

314 2009-02-10 11:26:49 23671 20235 RTE _SHMKERNEL=36580

315 2009-02-10 11:26:49 23671 20235 RTE SHOW_MAX_KB_STACK_USE=NO

316 2009-02-10 11:26:49 23671 20235 RTE SHOW_MAX_STACK_USE=NO

317 2009-02-10 11:26:49 23671 20235 RTE SIMULATE_VECTORIO=IF_OPEN_DIRECT_OR_RAW_DEVICE

318 2009-02-10 11:26:49 23671 20235 RTE SPINLOCK_BACKOFF_BASE=1

319 2009-02-10 11:26:49 23671 20235 RTE SPINLOCK_BACKOFF_FACTOR=2

320 2009-02-10 11:26:49 23671 20235 RTE SPINLOCK_BACKOFF_MAXIMUM=64

321 2009-02-10 11:26:49 23671 20235 RTE SPINLOCK_LOOP_COUNT=30000

322 2009-02-10 11:26:49 23671 20235 RTE STANDBY=1

323 2009-02-10 11:26:49 23671 20235 RTE SUBTREE_LOCKS=NO

324 2009-02-10 11:26:49 23671 20235 RTE SUPPRESS_CORE=NO

325 2009-02-10 11:26:49 23671 20235 RTE SYMBOL_DEMANGLING=NO

326 2009-02-10 11:26:49 23671 20235 RTE SYMBOL_RESOLUTION=YES

327 2009-02-10 11:26:49 23671 20235 RTE SYSTEMERROR=3

328 2009-02-10 11:26:49 23671 20235 RTE TABRGNS=8

329 2009-02-10 11:26:49 23671 20235 RTE TASKCLUSTER01=tw;al;ut;2000sv,100bup;10ev,10gc;

330 2009-02-10 11:26:49 23671 20235 RTE TASKCLUSTER02=ti,100dw;30000us;

331 2009-02-10 11:26:49 23671 20235 RTE TASKCLUSTER03=compress

332 2009-02-10 11:26:49 23671 20235 RTE TIME_MEASUREMENT=NO

333 2009-02-10 11:26:49 23671 20235 RTE TRACE_AK=NO

334 2009-02-10 11:26:49 23671 20235 RTE TRACE_ALLOCATOR=0

335 2009-02-10 11:26:49 23671 20235 RTE TRACE_CATALOG=0

336 2009-02-10 11:26:49 23671 20235 RTE TRACE_CLIENTKERNELCOM=0

337 2009-02-10 11:26:49 23671 20235 RTE TRACE_COMMON=0

338 2009-02-10 11:26:49 23671 20235 RTE TRACE_COMMUNICATION=0

339 2009-02-10 11:26:49 23671 20235 RTE TRACE_CONVERTER=0

340 2009-02-10 11:26:49 23671 20235 RTE TRACE_DATACACHE=0

341 2009-02-10 11:26:49 23671 20235 RTE TRACE_DATACHAIN=0

342 2009-02-10 11:26:49 23671 20235 RTE TRACE_DATAINDEX=0

343 2009-02-10 11:26:49 23671 20235 RTE TRACE_DATAPAM=0

344 2009-02-10 11:26:49 23671 20235 RTE TRACE_DATATREE=0

345 2009-02-10 11:26:49 23671 20235 RTE TRACE_DBPROC=0

346 2009-02-10 11:26:49 23671 20235 RTE TRACE_DEFAULT=NO

347 2009-02-10 11:26:49 23671 20235 RTE TRACE_DELETE=NO

[Former Member]

Part 4:

348: 2009-02-10 11:26:49 23671 20235 RTE TRACE_FBM=0

349: 2009-02-10 11:26:49 23671 20235 RTE TRACE_FILEDIR=0

350: 2009-02-10 11:26:49 23671 20235 RTE TRACE_FRAMECTRL=0

351: 2009-02-10 11:26:49 23671 20235 RTE TRACE_INDEX=NO

352: 2009-02-10 11:26:49 23671 20235 RTE TRACE_INSERT=NO

353: 2009-02-10 11:26:49 23671 20235 RTE TRACE_IOMAN=0

354: 2009-02-10 11:26:49 23671 20235 RTE TRACE_IPC=0

355: 2009-02-10 11:26:49 23671 20235 RTE TRACE_JOIN=0

356: 2009-02-10 11:26:49 23671 20235 RTE TRACE_KSQL=0

357: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOCKMANAGER=0

358: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOCK=NO

359: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOGACTION=0

360: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOGHISTORY=0

361: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOGPAGE=0

362: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOGTRANS=0

363: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LOGVOLUME=0

364: 2009-02-10 11:26:49 23671 20235 RTE TRACE_LONG=NO

365: 2009-02-10 11:26:49 23671 20235 RTE TRACE_MEMORY=0

366: 2009-02-10 11:26:49 23671 20235 RTE TRACE_MESSAGES=0

367: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECTCONTAINER=0

368: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECT_ADD=NO

369: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECT_ALTER=NO

370: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECT_FREE=NO

371: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECT_GET=NO

372: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OBJECT=NO

373: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_CONTAINERDIR=0

374: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_CONTEXT=0

375: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_ERROR=0

376: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_FLUSHCACHE=0

377: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_INTERFACE=0

378: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_KEYRANGE=0

379: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_KEY=0

380: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_LOCK=0

381: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_MEMORY=0

382: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_NEWOBJ=0

383: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_SESSION=0

384: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_STREAM=0

385: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_VAROBJECT=0

386: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OMS_VERSION=0

387: 2009-02-10 11:26:49 23671 20235 RTE TRACE_OPTIMIZE=NO

388: 2009-02-10 11:26:49 23671 20235 RTE TRACE_ORDER_STANDARD=NO

389: 2009-02-10 11:26:49 23671 20235 RTE TRACE_ORDER=NO

390: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGER=0

391: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_BUP=0

392: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_EV=2

393: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_GC=20

394: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_LW=5

395: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_PG=3

396: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_SV=5

397: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_TI=2

398: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_US=10

399: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES_UT=5

400: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PAGES=NO

401: 2009-02-10 11:26:49 23671 20235 RTE TRACE_PRIMARY_TREE=NO

402: 2009-02-10 11:26:49 23671 20235 RTE TRACE_QUERYREWRITE=0

403: 2009-02-10 11:26:49 23671 20235 RTE TRACE_RUNTIME=0

404: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SELECT=NO

405: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SHAREDSQL=0

406: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SQLMANAGER=0

407: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SRVTASKS=0

408: 2009-02-10 11:26:49 23671 20235 RTE TRACE_STOP_ERRORCODE=0

409: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SYNCHRONISATION=0

410: 2009-02-10 11:26:49 23671 20235 RTE TRACE_SYSVIEW=0

411: 2009-02-10 11:26:49 23671 20235 RTE TRACE_TABLE=0

412: 2009-02-10 11:26:49 23671 20235 RTE TRACE_TIME=NO

413: 2009-02-10 11:26:49 23671 20235 RTE TRACE_UPDATE=NO

414: 2009-02-10 11:26:49 23671 20235 RTE TRACE_VOLUME=0

415: 2009-02-10 11:26:49 23671 20235 RTE TRANS_HISTORY_SIZE=0

416: 2009-02-10 11:26:49 23671 20235 RTE TRANSRGNS=8

417: 2009-02-10 11:26:49 23671 20235 RTE TRANS_THRESHOLD_VALUE=60

418: 2009-02-10 11:26:49 23671 20235 RTE UKT_CPU_RELATIONSHIP=NONE

419: 2009-02-10 11:26:49 23671 20235 RTE _UNICODE=NO

420: 2009-02-10 11:26:49 23671 20235 RTE UPDATESTAT_PARALLEL_SERVERS=0

421: 2009-02-10 11:26:49 23671 20235 RTE UPDATESTAT_SAMPLE_ALGO=1

422: 2009-02-10 11:26:49 23671 20235 RTE UPDSTATWANTED=1

423: 2009-02-10 11:26:49 23671 20235 RTE USED_MAX_LOG_QUEUE_COUNT=1

424: 2009-02-10 11:26:49 23671 20235 RTE USESELECTFETCH=YES

425: 2009-02-10 11:26:49 23671 20235 RTE USEUNICODECOLUMNCOMPRESSION=NO

426: 2009-02-10 11:26:49 23671 20235 RTE USEVARIABLEINPUT=NO

427: 2009-02-10 11:26:49 23671 20235 RTE USE_COROUTINES=YES

428: 2009-02-10 11:26:49 23671 20235 RTE USEIOPROCS_ONLY=NO

429: 2009-02-10 11:26:49 23671 20235 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO

430: 2009-02-10 11:26:49 23671 20235 RTE USE_OPEN_DIRECT=NO

431: 2009-02-10 11:26:49 23671 20235 RTE USE_SYSTEM_PAGE_CACHE=YES

432: 2009-02-10 11:26:49 23671 20235 RTE UTILITYPROTFILE=dbm.utl

433: 2009-02-10 11:26:49 23671 20235 RTE UTILITY_PROTSIZE=100

434: 2009-02-10 11:26:49 23671 20235 RTE VOLUMENO_BIT_COUNT=8

435: 2009-02-10 11:26:49 23671 20235 RTE WORKDATASIZE=8192

436: 2009-02-10 11:26:49 23671 20235 RTE WORKSTACKSIZE=8192

437: 2009-02-10 11:26:49 23671 20235 RTE XP_CONVERTER_REGIONS=0

438: 2009-02-10 11:26:49 23671 20235 RTE XP_DATA_CACHE_RGNS=0

439: 2009-02-10 11:26:49 23671 20235 RTE XP_MAXPAGER=0

440: 2009-02-10 11:26:49 23671 20236 RTE Dump of all kernel parameters done