[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2683
  • Last Modified:

Start and Stop Workgroup engine via commands

Hi,

I am using Pervasive SQL workgroup V8. I woul dlike to know how I can Start and Stop Workgroup engine via commands so that I can put these in a batch file.

Does anyone know these commands?

Thanks
0
amerretz
Asked:
amerretz
  • 4
  • 3
1 Solution
 
mirtheilCommented:
To start:
w3dbsmgr.exe -srde
To stop:
pvkillwg.exe

Both of these are in the PVSW\BIN directory.
0
 
amerretzAuthor Commented:
I dont have a pvkillwg.exe in my bin folder.

Also how would I put this in a script?

Thanks
0
 
mirtheilCommented:
What's the exact version of PSQL you're using?  I'll check my V8 machine later but I believe it is installed with PSQL V8.5 and later.  

How you put it into a script is really up to you.  What knd of script are you talking about?  What are you trying to do with the script?
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
amerretzAuthor Commented:
I am using Pervasive Workgroup Version 8.6. The file you mentioned above is not in my BIN directory.

I would like to create a scipt that will shutdown the workgroup engine at a specific time for backup purposes then restart the engine after the backup is finished.

Thanks
0
 
mirtheilCommented:
hmm.  Okay. I checked my install toolkit for PSQL 8.6 and it is there. By default it's at:
C:\Install\Pervasive.SQL_8.6_install_toolkit\manual\pkg\winroot\PVSW\Bin
You'll need to download the V8 SP2 toolkit from:
www.pervasive.com/developerzone/sdk/toolkit.asp
The direct link is:
http://www.pervasive.com/ftp/ftp_check.asp?agree=3&download=78&file=/SDKComp/Toolkit/Pervasive.SQL_8.6_install_toolkit.exe&sSiteRedirection=/developerzone/sdk/toolkit.asp

One thing to be aware of, PVKILLWG.EXE will pop a message if there is a "client"/application currently using the system.  

Are you trying to backup the data files in use by PSQL or the PSQL engine itself?  If it's the data files, you should look at Continuous Operation mode as it'll  help and won't require the engine to be stopped.

As far as the engine goes, a simple batch file would be something like:

c:\pvsw\bin\pvkillwg.exe
... do other stuff ...
c:\pvsw\bin\w3dbsmgr.exe -srde

0
 
amerretzAuthor Commented:
I am trying to backup data which uses PSQL. The data is used by an accounting application. This application has a company data directory which contains a heap of *.dat files and some *.ddf files.

When reading the pervasive help guides on continuous opteration it gives examples on how to backup using the butil -startbu command. The file that it gives in the example is a *.mkd file. I cannot seem to find any reference in the accounting data which contains a *.mkd file.

How would my application be using pervasive in this case? Should I have a *mkd file somwhere?
0
 
mirtheilCommented:
The MKD extension is the default.  Each application may be different.  I've seen *.DB, *.DAT, and even no extension.  If you've got *.DAT and *.DDF, those are the data files.
 
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now