Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQLAnywhere logging to messages file

Created: 15 Feb 2013 | 6 comments

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?pag...), 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

Comments 6 CommentsJump to latest comment

Mark_Solutions's picture

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

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

diego.marco's picture

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's picture

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

diego.marco's picture

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?pag...) but it doesn't show any "-s none" setting (as the first article shows)...

Will Restore's picture

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

Will Restore -- where there is a Will there is a way

diego.marco's picture

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