Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Is it possible (undocumented feature?) to limit the size of Web service client information (-zoc) file?
Like -os for the database server message log file and -zs/-zn for the request log file.

asked 24 Apr '17, 04:49

Ilia63's gravatar image

Ilia63
1.2k515782
accept rate: 44%


I scanned the code... and there is currently no method to automatically limit the size of the HTTP client log file.

The method suggested by Volker - use an event to rotate the log - would be your best solution. If checking the size of the file does not work (due to OS not updating the meta data (size) of the file) then you could just decide to rotate the log every fixed period of time regardless of its size. E.g. you could change the file name every 6, 12, or 24 hours depending on your situation / requirements. You can use

call sa_server_option( 'WebClientLogFile', newname );

to set a new name for the log file.

permanent link

answered 24 Apr '17, 09:01

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

I don't think so but you could of course create an event that checks the file size of the log and switches to a new log when a particular size is reached (and then possibly remove the previous one). sa_server_option() will be of help here.

permanent link

answered 24 Apr '17, 05:01

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

converted 24 Apr '17, 09:04

For ASA12, I'm trying to get the zoc-file size using a proxy table:
CREATE SERVER d0;...
CREATE EXISTING TABLE t0 AT 'd0;;;.';
SELECT "size" FROM t0 where file_name=...
But before select I have to do refresh of zoc-file, i.e.:
SELECT xp_read_file( 'ASAWeb.txt',1 );
Otherwise, the zoc-file size remains zero.

(24 Apr '17, 08:21) Ilia63
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:

×438
×261
×48

question asked: 24 Apr '17, 04:49

question was seen: 1,720 times

last updated: 24 Apr '17, 09:01