The following database server properties can be used to access the database server console output from within SQL:

  • MaxMessage
  • Message
  • MessageText
  • MessageTime
  • MessageWindowSize

All these have been deprecated in v11. Nevertheless, they are still available in v12 and v16.

Question: What SQL feature is the recommended way to access the same information? I don't find any hint to that in v11 and above...

asked 19 Oct '13, 16:21

Volker%20Barth's gravatar image

Volker Barth
39.5k355539810
accept rate: 34%

edited 21 Oct '13, 05:38

1

Hm, I would like to link to the according DCX pages - however, DCX seems currently unavailable... - cf. this FAQ.

(19 Oct '13, 16:28) Volker Barth

The recommended method to access the server console messages is to use sa_server_messages system procedure - It can return the information in a much more efficient way.

permanent link

answered 21 Oct '13, 11:21

Mark%20Culp's gravatar image

Mark Culp
24.8k9139295
accept rate: 41%

Ah, I see - apparently, I missed that as a new feature in v11, possibly, because it's only index in the "What's new section" relates to the discontinued "SQL Anywhere deprecated and discontinued features ", particularly to the obsolete "sa_get_server_messages" system procedure...

(It should be noted that the new system procedure is contained in the "SQL Anywhere new features ยป Miscellaneous" section, not in the "System procedures and functions" as I might have expected.)

Resume: Wasn't there a question recently whether we rely on the documentation index? :)

(I would like to link to DCX if I only could. Why are you able to do so, Mark - some internal access method?)

(21 Oct '13, 12:54) Volker Barth
Replies hidden
1

I'll send a note to the doc team to get the procedure indexed properly.

Not sure why I can access DCX and you can't? There could be some external routing to sybase.com issue?... I'll make sure a ticket is open to get this resolved.

(21 Oct '13, 12:59) Mark Culp

Still not available on this side of the pond :( - this is what I get - not sure how many of these machines are yours:

7   261 ms   257 ms   254 ms  vlan70.csw2.NewYork1.Level3.net [4.69.155.126]
8   245 ms   241 ms   246 ms  ae-72-72.ebr2.NewYork1.Level3.net [4.69.148.37]
9   244 ms   243 ms   245 ms  4.69.135.185
10   245 ms   251 ms   249 ms  ae-61-61.csw1.SanJose1.Level3.net [4.69.153.2]
11   252 ms   245 ms   252 ms  ae-11-60.car1.SanJose1.Level3.net [4.69.152.3]
12  SYBASE-INC.car1.SanJose1.Level3.net [4.53.16.162] reports: 
Destination net unreachable
(21 Oct '13, 14:33) Justin Willey

FWIW, www.sybase.com is available for me - and this forum, too - what a surprise:)

(21 Oct '13, 15:51) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×40
×24
×10

question asked: 19 Oct '13, 16:21

question was seen: 2,252 times

last updated: 21 Oct '13, 15:51