SQLAnywhere logging to messages file

[dmpcore]

Hi all!

I've upgrade NetBackup from v6.5.4 to v7.5.0.4 recently (standalone) and it begun to fill /var/log/messages file in my master server with a lot of messages from SQLAnywhere:

Feb 15 06:03:47 debora SQLAnywhere(validation_eng): SQL Anywhere Personal Server Version 11.0.1.2745
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):  
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Copyright (c) 2011, iAnywhere Solutions, Inc.
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Portions copyright (c) 2011, Sybase, Inc. All rights reserved.
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):  
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): 8 logical processor(s) on 2 physical processor(s) detected.
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Processor limit (Personal Server): 1
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Maximum number of physical processors the server will use: 1
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): This server is licensed to:
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     NetBackup
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     Symantec Corporation
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Running Linux 2.6.18-238.9.1.el5 #1 SMP Fri Mar 18 12:42:39 EDT 2011 on X86_64
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Server built for X86_64 processor architecture
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): 102400K of memory used for caching
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Minimum cache size: 102400K, maximum cache size: 1048576K
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Using a maximum page size of 4096 bytes
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Starting database "validation_eng" (/usr/openv/db/staging/NBAZDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Database "validation_eng" (NBAZDB.db) started at Fri Feb 15 2013 06:03
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): This database is licensed for use with:
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     Application: CommonRepository
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     Company: VERITAS
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Database server started at Fri Feb 15 2013 06:03
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Trying to start SharedMemory link ...
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     SharedMemory link started successfully
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Trying to start TDS (TCPIP) link ...
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Starting on port 2638
Feb 15 06:03:47 debora SQLAnywhere(validation_eng):     TDS (TCPIP) link started successfully
Feb 15 06:03:47 debora SQLAnywhere(validation_eng): Now accepting requests
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Database "validation_eng" (NBAZDB.db) stopped at Fri Feb 15 2013 06:03
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Database server shutdown automatically after last database stopped
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): SQL Anywhere Personal Server Version 11.0.1.2745
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
Feb 15 06:03:48 debora SQLAnywhere(validation_eng):  
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Copyright (c) 2011, iAnywhere Solutions, Inc.
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Portions copyright (c) 2011, Sybase, Inc. All rights reserved.
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
Feb 15 06:03:48 debora SQLAnywhere(validation_eng):  
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): 8 logical processor(s) on 2 physical processor(s) detected.
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Processor limit (Personal Server): 1
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Maximum number of physical processors the server will use: 1
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): This server is licensed to:
Feb 15 06:03:48 debora SQLAnywhere(validation_eng):     NetBackup
Feb 15 06:03:48 debora SQLAnywhere(validation_eng):     Symantec Corporation
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Running Linux 2.6.18-238.9.1.el5 #1 SMP Fri Mar 18 12:42:39 EDT 2011 on X86_64
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Server built for X86_64 processor architecture
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): 102400K of memory used for caching
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Minimum cache size: 102400K, maximum cache size: 1048576K
Feb 15 06:03:48 debora SQLAnywhere(validation_eng): Using a maximum page size of 4096 bytes
Feb 15 06:03:49 debora SQLAnywhere(validation_eng): Starting database "validation_eng" (/usr/openv/db/staging/NBDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:49 debora SQLAnywhere(validation_eng): Opening dbspace 'EMM_DATA' in file '/usr/openv/db/staging/EMM_DATA.db' for database 'validation_eng'
Feb 15 06:03:49 debora SQLAnywhere(validation_eng): Database server stopped at Fri Feb 15 2013 06:03
Feb 15 06:03:49 debora SQLAnywhere(validation_eng): Opening dbspace 'EMM_INDEX' in file '/usr/openv/db/staging/EMM_INDEX.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'DBM_DATA' in file '/usr/openv/db/staging/DBM_DATA.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'DBM_INDEX' in file '/usr/openv/db/staging/DBM_INDEX.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'DARS_DATA' in file '/usr/openv/db/staging/DARS_DATA.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'DARS_INDEX' in file '/usr/openv/db/staging/DARS_INDEX.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'SEARCH_DATA' in file '/usr/openv/db/staging/SEARCH_DATA.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'SEARCH_INDEX' in file '/usr/openv/db/staging/SEARCH_INDEX.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Opening dbspace 'JOBD_DATA' in file '/usr/openv/db/staging/JOBD_DATA.db' for database 'validation_eng'
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Database "validation_eng" (NBDB.db) started at Fri Feb 15 2013 06:03
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): This database is licensed for use with:
Feb 15 06:03:50 debora SQLAnywhere(validation_eng):     Application: CommonRepository
Feb 15 06:03:50 debora SQLAnywhere(validation_eng):     Company: VERITAS
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Database server started at Fri Feb 15 2013 06:03
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Trying to start SharedMemory link ...
Feb 15 06:03:50 debora SQLAnywhere(validation_eng):     SharedMemory link started successfully
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Trying to start TDS (TCPIP) link ...
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Starting on port 2638
Feb 15 06:03:50 debora SQLAnywhere(validation_eng):     TDS (TCPIP) link started successfully
Feb 15 06:03:50 debora SQLAnywhere(validation_eng): Now accepting requests
Feb 15 06:03:53 debora SQLAnywhere(validation_eng): Database "validation_eng" (NBDB.db) stopped at Fri Feb 15 2013 06:03
Feb 15 06:03:53 debora SQLAnywhere(validation_eng): Database server shutdown automatically after last database stopped
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): SQL Anywhere Network Server Version 11.0.1.2745
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):  
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Copyright (c) 2011, iAnywhere Solutions, Inc.
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Portions copyright (c) 2011, Sybase, Inc. All rights reserved.
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):  
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): 8 logical processor(s) on 2 physical processor(s) detected.
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Processor limit (licensed processors): 128
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Maximum number of physical processors the server will use: 2
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): This server is licensed to:
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):     NetBackup
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):     Symantec Corporation
Feb 15 06:03:53 debora SQLAnywhere(validation_eng): Database server stopped at Fri Feb 15 2013 06:03
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Running Linux 2.6.18-238.9.1.el5 #1 SMP Fri Mar 18 12:42:39 EDT 2011 on X86_64
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Server built for X86_64 processor architecture
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): 102400K of memory used for caching
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Minimum cache size: 102400K, maximum cache size: 1048576K
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Using a maximum page size of 4096 bytes
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Starting database "NBAZDB" (/usr/openv/db/staging/NBAZDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:53 debora SQLAnywhere(nbazdb): Database recovery in progress
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):     Last checkpoint at Fri Feb 15 2013 06:00
Feb 15 06:03:53 debora SQLAnywhere(nbazdb):     Transaction log: /usr/openv/db/staging/NBAZDB.log.1...
Feb 15 06:03:54 debora SQLAnywhere(nbazdb):     Checkpointing...
Feb 15 06:03:54 debora SQLAnywhere(nbazdb): Starting checkpoint of "NBAZDB" (NBAZDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:54 debora SQLAnywhere(nbazdb): Finished checkpoint of "NBAZDB" (NBAZDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:54 debora SQLAnywhere(nbazdb): Recovery complete
Feb 15 06:03:54 debora SQLAnywhere(nbazdb): Database server shutdown automatically after log applied
Feb 15 06:03:54 debora SQLAnywhere(nbazdb): Database server stopped at Fri Feb 15 2013 06:03
Feb 15 06:03:54 debora SQLAnywhere(nbdb): SQL Anywhere Network Server Version 11.0.1.2745
Feb 15 06:03:54 debora SQLAnywhere(nbdb): OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
Feb 15 06:03:54 debora SQLAnywhere(nbdb):  
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Copyright (c) 2011, iAnywhere Solutions, Inc.
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Portions copyright (c) 2011, Sybase, Inc. All rights reserved.
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
Feb 15 06:03:54 debora SQLAnywhere(nbdb):  
Feb 15 06:03:54 debora SQLAnywhere(nbdb): 8 logical processor(s) on 2 physical processor(s) detected.
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Processor limit (licensed processors): 128
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Maximum number of physical processors the server will use: 2
Feb 15 06:03:54 debora SQLAnywhere(nbdb): This server is licensed to:
Feb 15 06:03:54 debora SQLAnywhere(nbdb):     NetBackup
Feb 15 06:03:54 debora SQLAnywhere(nbdb):     Symantec Corporation
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Running Linux 2.6.18-238.9.1.el5 #1 SMP Fri Mar 18 12:42:39 EDT 2011 on X86_64
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Server built for X86_64 processor architecture
Feb 15 06:03:54 debora SQLAnywhere(nbdb): 102400K of memory used for caching
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Minimum cache size: 102400K, maximum cache size: 1048576K
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Using a maximum page size of 4096 bytes
Feb 15 06:03:54 debora SQLAnywhere(nbdb): Starting database "NBDB" (/usr/openv/db/staging/NBDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'EMM_DATA' in file '/usr/openv/db/staging/EMM_DATA.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'EMM_INDEX' in file '/usr/openv/db/staging/EMM_INDEX.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'DBM_DATA' in file '/usr/openv/db/staging/DBM_DATA.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'DBM_INDEX' in file '/usr/openv/db/staging/DBM_INDEX.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'DARS_DATA' in file '/usr/openv/db/staging/DARS_DATA.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'DARS_INDEX' in file '/usr/openv/db/staging/DARS_INDEX.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'SEARCH_DATA' in file '/usr/openv/db/staging/SEARCH_DATA.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'SEARCH_INDEX' in file '/usr/openv/db/staging/SEARCH_INDEX.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Opening dbspace 'JOBD_DATA' in file '/usr/openv/db/staging/JOBD_DATA.db' for database 'NBDB'
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Database recovery in progress
Feb 15 06:03:55 debora SQLAnywhere(nbdb):     Last checkpoint at Fri Feb 15 2013 06:00
Feb 15 06:03:55 debora SQLAnywhere(nbdb):     Transaction log: /usr/openv/db/staging/NBDB.log.1...
Feb 15 06:03:55 debora SQLAnywhere(nbdb):     Checkpointing...
Feb 15 06:03:55 debora SQLAnywhere(nbdb): Starting checkpoint of "NBDB" (NBDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:56 debora SQLAnywhere(nbdb): Finished checkpoint of "NBDB" (NBDB.db) at Fri Feb 15 2013 06:03
Feb 15 06:03:56 debora SQLAnywhere(nbdb): Recovery complete
Feb 15 06:03:56 debora SQLAnywhere(nbdb): Database server shutdown automatically after log applied
Feb 15 06:03:56 debora SQLAnywhere(nbdb): Database server stopped at Fri Feb 15 2013 06:03

This messages are registered when NBU makes a hot catalog backup (everyday at 6am). Nor errors or warnings shown in NBU about jobs.

I found this KB (http://www.symantec.com/business/support/index?page=content&id=TECH57877), but setting "-s none" in my /usr/openv/var/global/server.conf doesn't work in my environment.

Here is my server.conf:
-n NB_debora
   -x tcpip(LocalOnly=YES;ServerPort=13785)  -gp 4096 -gd DBA -gk DBA -gl DBA -ti 0 -c 100M -ch 1024M -cl 100M -zl -os 1M -o /usr/openv/db/log/server.log -s none
 -ud -m
 

Before the upgrade, without SQLAnywhere loggin in messages,  my server.conf was like:

-n NB_debora
   -x tcpip(LocalOnly=YES;ServerPort=13785)  -gp 4096 -ct+ -gd DBA -gk DBA -gl DBA -ti 0 -c 25M -ch 500M -cl 25M -zl -os 1M  -ua  -o /usr/openv/db//log/server.log
 -ud
 

I know that in v7.5 hot catalog backup changes some checkpoints from file to DB, and the entries in messages are not a problem, but they're annoying... anyone who know how to stop debugging in /etc/messages?

Thanks a lot in advance!

Diego

[Mark_Solutions]

Sounds like this one if it is restricting it to one processor:

http://www.symantec.com/docs/TECH178219

Perhaps once you have changed the setting it will stop complaining so much

Let us know if this helps

[diego_marco]

Don't think so Mark... for several reasons:

 * I'm not having performance issues at all.

 * This issue affects only Windows environments on NetBackup 7.1.0.3. My environment is RHEL 5.6 on NetBackup 7.5.0.4.

And the fix is for 7.1.0.3, I can't apply in 7.5.x.

Thanks!

diego

[Dyneshia]

Please review : http://www.symantec.com/docs/DOC5198  page 30 regarding suggested setting for the server.conf

[Will_Restore]

We get that all message text on 7.1 Linux Master with every Catalog backup. 

[diego_marco]

Dyneshia,

As you can see, my server.conf configuration is as the document recomends... minimun cache 1GB, and -m for limiting transaction log. But this settings are for improve performance in migration process...

I saw also this HOWTO (http://www.symantec.com/business/support/index?page=content&id=HOWTO34665) but it doesn't show any "-s none" setting (as the first article shows)...

[diego_marco]

Yeah, I think these messages are logged due to changes in hot catalog backup in 7.x versions.