Database Page - When you have made your changes, click:

3 WebWare Server Module

5. When you have made your changes, click:

3.2.5. Database Page

97 3HAC031359-001 Revision: B

3.2.5. Database Page

Introduction

Use the Database page to configure the WebWare database location, user name and password as well as managing database archiving and archive history.

The Database page contains three panels:

• Database Configuration - contains details about connection state, version information and server configuration.

• Archive Configuration - contains details about archive storage, manual archiving and scheduled archiving of the database.

• Archive History - displays a table with details about available database archives.

Default WebWare User Name and Password

The default user name and password established for the database when WebWare Server is first installed is:

User name: sa Password: webware

User Interface - Database Configuration Panel

xx0500001643

Continues on next page

3.2.5. Database Page

Screen Components - WebWare Server State

The table below describes the function of the screen components in the WebWare Server State section of the Database Configuration drop-down panel on the Database Administration page.

Screen Components - WebWare Database Information

The table below describes the function of the screen components in the WebWare Database Information section of the Database Configuration drop-down panel on the Database Admin-istration page.

Screen Components - Database Server Configuration

The table below describes the function of the screen components in the Database Server Con-figuration section of the Database ConCon-figuration drop-down panel on the Database Adminis-tration page.

Component Function

Connection State Indicates the current status of the WebWare database.

Possible values are:

• Running - Database is connected and running.

• Stopped - Database is stopped.

• Reboot Required - WebWare Server must be rebooted to re-initialize the database.

• Archiving - Database is currently being archived.

Message Displays database status and error messages.

Queue Length Number of messages currently in the queue.

MSMQ Enabled Indicates MSMQ status. Possible options are:

• True - MSMQ is installed and running.

• False - MSMQ is not running.

For more information, see Overview on page 36.

Refresh button Click to update the database connection state.

Component Function

Size in MB This is the size of the Webware database in megabytes. The database has a default size allotted when WebWare Server is first installed. The database will continue to grow over time. If your system is using the MSDE version of the database this is an important field to monitor.

For more information, see Archive Process on page 103.

Creation Date Date the currently installed database was first created.

Version Database version (DeviceLog.mdf version).

SQL Server Version Software version.

Component Function

SQL Server Name This is the machine name of the SQL server.

SQL Instance This is the name of the instance that WebWare will use.

Database Location WWService.exe checks SQL Server to determine whether a database labeled DeviceLog.mdf exists. If the database exists, this field is ignored. If SQL Server does not recognize Continued

3.2.5. Database Page

99 3HAC031359-001 Revision: B

Troubleshooting

• If you have forgotten the instance name, you can find it in the SQL Server Enterprise Manager.

• Some SQL Server Editions do not allow the creation of instances. If you do not have an instance name, leave the SQL Instance box empty.

• Some domain settings might block the use of PC designations. If so, instead of the PC name, enter the TCP/ID address of the SQL Server.

• Some SQL Server editions demand that you restart the SQL server PC before broadcasting a new database.

• If you place the database on another drive than C:\, then WebWare might not find the database files. If you have an attached database, insert a blankspace in the Database Location box.

• In some SQL networks, the sa account might be disabled. If so, either create a new SQL user for WebWare,or use Windows Authentication.

Authentication Type SQL can use two types of user authentication. Click on either:

• Windows - to use Windows-specific user name/

password when logging in to the database.

• SQL Server - to use SQL Server-specific user name/

password when logging in to the database.

User Name This field lists the user name that WebWare should use when accessing the database.

NOTE: You are NOT setting the user name here - the name is set either by the Windows network or by the SQL database administrator.

NOTE: For details about the default database user name and password established when WebWare Server is first installed, see Default WebWare User Name and Password on page 97.

Password This field lists the password that WebWare should use when accessing the database.

NOTE: You are NOT setting the password here - the password is set either by the Windows network or by the SQL database administrator.

NOTE: For details about the default database user name and password established when WebWare Server is first installed, see Default WebWare User Name and Password on page 97.

Retype Password Verify the password entered in the Password field.

Set Configuration button Click to apply the settings.

Component Function

Continued

Continues on next page

3.2.5. Database Page

User Interface - Archive Configuration Panel

xx0500001644

Screen Components - Archive Storage

The table below describes the function of the components on the Archive Storage part of the Archive Configuration drop-down panel on the Database Administration page.

Screen Components - Manual Archive

The table below describes the function of the components on the Manual Archive part of the Archive Configuration drop-down panel on the Database Administration page.

Component Function

Available Diskspace Displays the available disk space on connected harddisks.

Number of archives to retain on harddisk

Enter the number of recent archives you wish to retain on the harddisk. Default is 10 archives.

Retain all archives check box Select to retain all archives on the harddisk.

Automatically shrink database check box

Select to automatically shrink the transaction log of the database. For details, see Archive Process on page 103.

Set Archive Options button Click to set archive options.

Component Function

Archive Directory Format Enter the format you wish to use for the folder that contains the archived WebWare database files.

Reset button Click to reset the format to the last saved format.

Test Format button Click to display an example of what the database archive file folder name will look like.

Number of days to be retained in the database

Enter the number of days worth of data to be retained in the database. Default is to retain all data. See Archive Creation on page 104.

Continued

3.2.5. Database Page

101 3HAC031359-001 Revision: B

Screen Components - Scheduled Archive

The table below describes the function of the components on the Scheduled Archive part of the Archive Configuration drop-down panel on the Database Administration page.

Shrink Database after archive check box

Select to shrink the WebWare database, see Archive Process on page 103.

NOTE: Shrinking the database locks the database while executing. Performance will be degenerated while this command is being executed.

Archive Now button Click to start the archive process. The database will be copied to a folder created inside the folder containing the Robot Data folder and the DeviceLog.mdf file. The status of the manual archive procedure is displayed in the User Interface - Archive History Panel on page 102.

Component Function

Archive Directory Format Enter the format you wish you use for the folder that contains the archived WebWare database files.

Reset button Click to reset the format to the last saved format.

Test Format button Click to display an example of what the database archive file folder name will look like.

Number of days to be retained in the database

Enter the number of days worth of data to be retained in the database. Default is to retain all data. See Archive Creation on page 104.

Retain all data check box Select to retain all data in the database.

Number of archives to be retained

Enter the number of scheduled archives to retain. Default is 5.

Run task: list boxes Use these list boxes to set the archive frequency. Choose from:

• Frequency - Every, First, Second, Third, Fourth, Last

• Weekday - Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

“at” list box Use this list box to select what time of day the scheduled archive should run. Choose from Midnight, 1 AM, 2 AM, etc.

or 00, 01, 02, etc.

Set Archive Schedule button Click to apply the archive schedule to the system. The database will be backed up at the regularly scheduled date and time.

Continued

Continues on next page

3.2.5. Database Page

User Interface - Archive History Panel

xx0500001879

Screen Components - Archive History

The table below describes the function of the components in the Archive History Table part of the Archive History drop-down panel on the Database Administration page.

Component Function

Refresh button Click to refresh the Archive History Table.

Archive History table Displays a list of all archives done containing the following information:

• Archive Date - date and time the archive was executed.

• Path - location where the archive was stored.

• Size - file size of the archive in megabytes.

• Status - if the archive was successful or failed.

• Type - if the archive was manual or scheduled.

• Days retained - number of days to retain in the archive, possible options include All or a numeric value.

• Comment - Displays text confirming the status of the archive, e.g. Archive completed without errors or Archive completed with errors.

Continued

3.2.5. Database Page

103 3HAC031359-001 Revision: B

Archive Process

For sites using only Microsoft SQL Desktop Engine (MSDE) for the WebWare database, a possible problem may occur as the device log database (DeviceLog.mdf) and transaction log reaches the MSDE 2-gigabyte limit.

To resolve this problem, the database and transaction log can be truncated and physically shrunk after a manual archive procedure by selecting the Shrink Database after archive check box on the Database Administration, Archive Cofiguration panel.

The size of the files are physically reduced when:

• A DBCC SHRINKDATABASE statement is executed.

• A DBCC SHRINKFILE statement referencing a log file is executed.

• An autoshrink operation occurs.

Shrinking a log is dependent on first truncating the log. Log truncation occurs at these points:

• At the completion of any BACKUP LOG statement.

• Every time a checkpoint is processed, provided the database is using the simple recovery model.

The archive process purges both default and custom tables from the database.

When the Automatically Shrink Database check box is selected, the AUTO_SHRINK option of the WebWare database is turned on. SQL Server will periodically reduce the size of the WebWare database and transaction log. Be aware that this option resets the Recovery Model of the WebWare database to "Simple". Therefore, scheduled backups of the WebWare database transaction log will not be possible. AUTO_SHRINK only reduces the size of the transaction log if the database is set to SIMPLE recovery model or if the log is backed up. If your organization requires continual backups of the transaction log for maximum data protection, this option should not be selected. This option is used primarily by WebWare customers using the Microsoft SQL Server Desktop Engine which has a 2-GB size limit.

The AUTO_SHRINK option causes files to be shrunk when more than 25 % of the file contains unused space. The file is shrunk to a size where 25 % of the file is unused space, or to the size of the file when it was created, whichever is greater.

For additional information, please refer to your Microsoft SQL Server documentation or http://support.microsoft.com.

Archive Locations

Archived database files are located at the following default path:

C:\Program Files\Common Files\ABB Automation\WebWare Server\Robot Data\Archive

The folder name is configurable. The default archive folder name is:

%m-%d-%Y_%H_%M_%S

(read as Month-Day-Year_Hour_Minute_Second).

For details on configuring the folder name, see How to Configure Backup and Archive File Folder Names on page 113.

NOTE: The order of the day/date data can vary depending on local system settings.

Continued

Continues on next page

3.2.5. Database Page

Archive Creation

When creating an archive, Webware Server takes a copy of the entire database. Consequently, any data that has been retained might be inadvertantly duplicated the next time the database is archived. Take this into consideration when configuring the Database page.

Continued

In document Administrator s Guide WebWare Server (Page 97-105)