# 22. Virtuoso Functions Guide - repl_new_log

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
repl_add_cr
repl_add_dav_cr
repl_add_snapshot_cr
repl_create_snapshot...
repl_create_snapshot...
repl_drop_snapshot_p...
repl_drop_snapshot_s...
repl_grant
repl_init_copy
repl_init_snapshot
repl_publish
repl_pub_add
repl_pub_init_image
repl_pub_remove
repl_revoke
repl_sched_init
repl_server
repl_server_name
repl_snp_server
repl_stat
repl_subscribe
repl_unpublish
repl_unsubscribe
repl_update_snapshot
repl_disconnect
repl_new_log
repl_purge
repl_server_rename
repl_status
repl_sync
repl_sync_all
repl_text
repl_this_server
sub_schedule
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## repl_new_log

create new publication log
repl_new_log (in publication varchar, in file varchar);
Description

This function switches to a new file for logging data for the publication. If the file is NULL a new file name will be generated based on the previous file name by appending or replacing a datetime field in the file name.

Parameters
publication – publication account name.
file – name of file to be used for publication's transactions logging, if size exceed 1Mb limit a new file suffixed with timestamp will be oppened.
Example
Openning a new replication log

This command can be issued on the publisher server to swith replication logging to the new file 'new_log_file_name.log'. Inpractice we making a publication with REPL_PUBLISH() and it opens the replication log file, so this is for maintenance only. Furthermore the replication server will switch to a new log suffixed with timestamp when current file is greater than 1,000,000 bytes.

    SQL> repl_new_log ('demo-publication', 'new_log_file_name.log');

See Also

sub_schedule()

repl_disconnect()

repl_grant()

repl_init_copy()

repl_new_log()

repl_pub_add()

repl_pub_init_image()

repl_pub_remove()

repl_publish()

repl_revoke()

repl_sched_init()

repl_server()

repl_server_rename()

repl_stat()

repl_status()

repl_subscribe()

repl_sync()

repl_sync_all()

repl_text()

repl_this_server()

repl_unpublish()

repl_unsubscribe()