What language is used for checkpoint console messages in non-English versions?

[Breck_Carter]

Do the following server console messages always appear in English, or does the language depend on the installed language of SQL Anywhere 11.0.1?

Starting checkpoint of "ddd11" (ddd11.db) at Fri Jan 21 2011 07:18
Finished checkpoint of "ddd11" (ddd11.db) at Fri Jan 21 2011 07:18

I am writing code to watch for checkpoints by calling sa_server_messages() every once in a while, and I want to tell the "Starting" apart from the "Finished".

I am happy to build in a table of translations... IF I knew what words are actually used 🙂

Thanks!

[VolkerBarth]

BTW, what about testing/"debugging" with the DBLANG tool?

[Breck_Carter]

@Volker: Awesome suggestion! ( hope it works 🙂

[VolkerBarth · Accepted solution]

SQL Anywhere Network Server Version 11.0.1.2427 in a German setup (the same with 12.0.0.2601):

Start des Checkpoints von "ddd11" (ddd11.db) am/um Freitag, 21. Januar 2011 17:05
Setzen des Checkpoints von "ddd11" (ddd11.db) beendet am/um Freitag, 21. Januar 2011 17:05

Graeme will help to translate:)

---

Volker suggested using dblang.exe, and that works pretty well... except that the result for several languages is not readable, in either the resulting dbeng11 -o file or the result set returned by sa_server_messages. Here are the checkpoint-related excerpts from all the -o files produced after dblang.exe changed the language:

LANG_DE.txt
I. 22.01 05:53:04. Start des Checkpoints von "ddd11" (ddd11.db) am/um Samstag, 22. Januar 2011 05:53
I. 22.01 05:53:04. Setzen des Checkpoints von "ddd11" (ddd11.db) beendet am/um Samstag, 22. Januar 2011 05:53

LANG_EN.txt
I. 01/22 05:54:10. Starting checkpoint of "ddd11" (ddd11.db) at Sat Jan 22 2011 05:54
I. 01/22 05:54:10. Finished checkpoint of "ddd11" (ddd11.db) at Sat Jan 22 2011 05:54

LANG_ES.txt
I. 22/01 05:53:09. Inicio de verificación "ddd11" (ddd11.db) el Sáb, 22 ene 2011 05:53
I. 22/01 05:53:09. Verificación "ddd11" (ddd11.db) completada el Sáb, 22 ene 2011 05:53

LANG_FR.txt
I. 22/01 05:53:14. Démarrage du point de reprise de "ddd11" (ddd11.db) le sam 22 jan 2011 05:53
I. 22/01 05:53:14. Le point de reprise de "ddd11" (ddd11.db) s'est achevé le sam 22 jan 2011 05:53

LANG_IT.txt
I. 22/01 05:53:19. Avvio del punto di arresto di "ddd11" (ddd11.db): sabato, 22 gennaio 2011 05:53
I. 22/01 05:53:19. Terminato il punto di arresto di "ddd11" (ddd11.db): sabato, 22 gennaio 2011 05:53

LANG_JA.txt
I. 01/22 05:53:25. Sat Jan 22 2011 05:53  "ddd11" (ddd11.db) 
I. 01/22 05:53:25. Sat Jan 22 2011 05:53  "ddd11" (ddd11.db)

LANG_KO.txt
I. 01/22 05:53:30. Sat Jan 22 2011 05:53 "ddd11"(ddd11.db)  .
I. 01/22 05:53:30. Sat Jan 22 2011 05:53 "ddd11"(ddd11.db)  .

LANG_LT.txt
I. 01/22 05:53:35. Pradedamas tikrinti "ddd11" (ddd11.db) kontrolinis taškas Šeš, 2011 Sau 22 05:53
I. 01/22 05:53:35. "ddd11" (ddd11.db) kontrolinio taško pabaiga Šeš, 2011 Sau 22 05:53

LANG_PL.txt
I. 22/01 05:53:40. Pocztek punktu kontrolnego "ddd11" (ddd11.db) o Sob 22 Sty 2011 05:53
I. 22/01 05:53:40. Zakoczono punkt kontrolny "ddd11" (ddd11.db) o Sob 22 Sty 2011 05:53

LANG_PT.txt
I. 22/01 05:53:45. Iniciando o checkpoint de "ddd11" (ddd11.db), Sáb, 22 jan 2011 05:53
I. 22/01 05:53:45. Checkpoint de "ddd11" (ddd11.db) terminado Sáb, 22 jan 2011 05:53

LANG_RU.txt
I. 22/01 05:53:51.    "ddd11" (ddd11.db)  ?? 22 ??? 2011 05:53
I. 22/01 05:53:51.    "ddd11" (ddd11.db)  ?? 22 ??? 2011 05:53

LANG_TW.txt
I. 01/22 05:53:56.  "ddd11" (ddd11.db)  Sat Jan 22 2011 05:53
I. 01/22 05:53:56.  "ddd11" (ddd11.db)  Sat Jan 22 2011 05:53

LANG_UK.txt
I. 22/01 05:54:01.    "ddd11" (ddd11.db)  ??? 22 ??? 2011 05:54
I. 22/01 05:54:01.    "ddd11" (ddd11.db)  ??? 22 ??? 2011 05:54

LANG_ZH.txt
I. 01/22 05:54:06? Sat Jan 22 2011 05:54  "ddd11" (ddd11.db)
I. 01/22 05:54:06? Sat Jan 22 2011 05:54  "ddd11" (ddd11.db) 

[VolkerBarth · Accepted solution]

BTW, that doesn't answer the title question, but I hope it satisfies the "...IF I knew" part:)

[graeme_perrow · Accepted solution]

Yep, "Checkpoints" is the first German word I learned after "der Lippenstift", though I don't use either one all that often. 🙂

[Breck_Carter · Accepted solution]

@Volker: It doesn't answer the title question? I thought it did... unless "Start des Checkpoints..." isn't German 🙂

[Breck_Carter · Accepted solution]

@Graeme: That sounds pornografisch 🙂

[johnsmirnios · Accepted solution]

Server messages are written to the console log file in OS language & OS character set. Characters in some languages are not representable in some character sets. Fetching messages from the server via sa_server_messages() will also pass the strings through a translation to database charset then to client charset. Parsing messages in multiple languages and character sets will be very, very painful.

[VolkerBarth · Accepted solution]

@Breck: Interestingly enough, the really well-done German doc setup doesn't have a translation for "Checkpoint", so, yes, Graeme is right, it's an German word, obviously ... cf. http://dcx.sybase.com/index.html#1200de/dbreference/checkpoint-statement.html. It's nice that SQLA helps me understanding my native language better:)

[VolkerBarth · Accepted solution]

@Breck: According to the timestamps, the German version is the fastest w.r.t. checkpointing - now that's OK with me:)

[former_SQLA_member1694880 · Accepted solution]

Under Russian Windows (SA10.0.1.4157 on WinXP SP3 Prof Rus), it is perfectly readable as follows:

I. 23/01 00:08:13. Запуск контрольной точки "trade" (trade.db) в Вс 23 Янв 2011 00:08 I. 23/01 00:08:13. Завершение контрольной точки "trade" (trade.db) в Вс 23 Янв 2011 00:08

(not that it makes sense for those who does not know Russian :))

[johnsmirnios]

Would watching for increments in db_property('Chkpt') work for you or are you parsing the messages as part of some other analysis too?

[Breck_Carter]

Oops, I forgot about that property 🙂 What I am watching for is a checkpoint that starts but never ends, where the definition of "never" is to be determined. Sooo, db_property ( 'chkpt' ) won't help because it treats a checkpoint as an instant-in-time event... it doesn't matter if it's set at the start, middle or end of a checkpoint, I need both start and end.