1. Magicu-L | Main
  2. Topics

Pervasive SQL V8.0 to a newer version

marwin mesa
 

Hi Magic u/l group:

1) our current setup is we are using Pervasive SQL v8.10  in a Virtual Server running Windows Server 2003
2) We are using Unipaas 1.9C in  separate Windows Server 2003 32bit / Windows Server 2008 32 bit/ Windows 10 64 bit  to access that Pervasive SQL
 
3) In the future we would like to use a higher version of Magic XPA than the 1.9 C
4) we would probably install  The newer Pervasive SQL probably v12 or higher into a windows server 2012 64 bit
 
 
So the questions are:
 
1)  What is the latest Pervasive  SQL version and model that you have worked on before and/or you would suggest for us to use that can be installed on Windows Server 2012/2016  and  can be connected to Unipaas 1,9c/ Magic XPA
 
2) Which vendor/reseller do you suggest for us to have the Pervasive SQL?
 
3) Do someone offer Services in guiding us to  install/configure and connecting the new Pervasive SQL to Unipaas 1.9C  ?
 
Regards
Steven Blank
 

Marwin,

I would recommend at least v13, if not the latest version, v14 (released in August), and definitely 64-bit. The product has been rebranded as Actian Zen in v14, but it's fully backward-compatible with Magic's "Pervasive ISAM" and "Pervasive SQL" gateways.

For licenses and support, I recommend Bill Bach at Goldstar Software for both.

www.goldstarsoftware.com

Steve Blank

On 10/28/2019 6:36 PM, marwin mesa via Groups.Io wrote:

Hi Magic u/l group:

1) our current setup is we are using Pervasive SQL v8.10  in a Virtual Server running Windows Server 2003
2) We are using Unipaas 1.9C in  separate Windows Server 2003 32bit / Windows Server 2008 32 bit/ Windows 10 64 bit  to access that Pervasive SQL
 
3) In the future we would like to use a higher version of Magic XPA than the 1.9 C
4) we would probably install  The newer Pervasive SQL probably v12 or higher into a windows server 2012 64 bit
 
 
So the questions are:
 
1)  What is the latest Pervasive  SQL version and model that you have worked on before and/or you would suggest for us to use that can be installed on Windows Server 2012/2016  and  can be connected to Unipaas 1,9c/ Magic XPA
 
2) Which vendor/reseller do you suggest for us to have the Pervasive SQL?
 
3) Do someone offer Services in guiding us to  install/configure and connecting the new Pervasive SQL to Unipaas 1.9C  ?
 
Regards
marwin mesa
 

Hi Steven

Thank you for your reply,
 
this would be the first time for me to install Pervasive/Actian Zen,  and i'm not sure of goldstar team  would actually assist us to the point of connecting it to our Unipaas 1.9C.. and if they are familiar with the unipaas systems
 
are you offiering that service or know someone who might be ?
marwin mesa
 
Edited

Hi Guys,

1) I Installed Zen PSQL v14 Server  on the host server
2) I Installed Zen PSQL v14 Client  on the client server
3) I Changed the UNC to point to the host server
4) I checked my file version via butil, it is v8
5) i Tried Zen System Analyzer from client to server and it worked
6) I tried to open unipaas runtime and encountered error 170: File Manager Error

I've attached file to this message of the Steps i've done and encountered issue

Any steps i missed that is causing the error 170 file manager error?  thanks

Zen PSQL v14 config to Unipaas 1.9C.pdf

Zen PSQL v14 config to Unipaas 1.9C.pdf

Danica Majernikova
 

You have to uninstall the older versions of Pervasive before installation of a new one.


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of marwin mesa via Groups.Io <marwinmesa@...>
Sent: October 29, 2019 10:06 PM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: Re: [magicu-l] Pervasive SQL V8.0 to a newer version
 

[Edited Message Follows]

Hi Guys,

1) I Installed Zen PSQL v14 Server  on the host server
2) I Installed Zen PSQL v14 Client  on the client server
3) I Changed the UNC to point to the host server
4) I checked my file version via butil, it is v8
5) i Tried Zen System Analyzer from client to server and it worked
6) I tried to open unipaas runtime and encountered error 170: File Manager Error

I've attached file to this message of the Steps i've done and encountered issue

Any steps i missed that is causing the error 170 file manager error?  thanks

Wes Hein
 

Doesn't hurt to Google that error code either.  You might want to use the 'Rebuild' program to get all your files up to current format.  Around v9, pre 6.x btrieve files can only be read and will return a status 46 if you try to write to them.  Rebuilding your data to a current File format may be a good thing after you figure out the 170.

Wes
Danica Majernikova
 

Also,
client has to be installed on a client machine, not a server, and point to the host server. You check the manual

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of marwin mesa via Groups.Io <marwinmesa@...>
Sent: October 29, 2019 10:06 PM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: Re: [magicu-l] Pervasive SQL V8.0 to a newer version
 

[Edited Message Follows]

Hi Guys,

1) I Installed Zen PSQL v14 Server  on the host server
2) I Installed Zen PSQL v14 Client  on the client server
3) I Changed the UNC to point to the host server
4) I checked my file version via butil, it is v8
5) i Tried Zen System Analyzer from client to server and it worked
6) I tried to open unipaas runtime and encountered error 170: File Manager Error

I've attached file to this message of the Steps i've done and encountered issue

Any steps i missed that is causing the error 170 file manager error?  thanks

marwin mesa
 

Thank you Danica and Wes,

i uninstalled the older version of Pervasive client, and installed the new one after your suggestion.

I was able to fix the #170 by restarting the Host and Client Server, and was able to proceed with the testing.

I'll be rebuilding the data to current file format after several other tests.

I'll also try out The Pervasive Cloud License,  we think that it would be much cheaper for our company to avail that instead of the Per User License.

I'll Post here if i encounter any problems during Installation of the Cloud License Model.

Thanks
Wes Hein
 

I'm assuming you are using the 30 day trial.  After the system has been in use for awhile, check the Monitor: Resource Usage tab to check your statistics; Data In Use and User Count.  In our case, the vX license makes more sense once you approach 20 users.  Rebuilding the files will reduce your data useage.  The cloud license works great for us but the Resource Usage should help you make an informed decision.  Pervasive upped the Data In Use to 20 GIG for a small so that is really nice, 100 GIG for a medium. 

Wes
marwin mesa
 

On Wed, Oct 30, 2019 at 05:00 PM, Wes Hein wrote:
I'm assuming you are using the 30 day trial.  After the system has been in use for awhile, check the Monitor: Resource Usage tab to check your statistics; Data In Use and User Count.  In our case, the vX license makes more sense once you approach 20 users.  Rebuilding the files will reduce your data useage.  The cloud license works great for us but the Resource Usage should help you make an informed decision.  Pervasive upped the Data In Use to 20 GIG for a small so that is really nice, 100 GIG for a medium. 
Thank you , i now see our total data use for 1 small test application = 229mb,

Question:  If there are 2 users opening the same application and accessing the same data  will it count as 229mb  or 458mb in the resource usage.  (i couldn't test as of the moment as all our other TSPLUS license is currently being used)
Wes Hein
 

Not necessarily, think of it kind of like a demand charge for electricity, a motor uses a lot to start but much less after so as long as 2 or more users don't do a high demand process at the same time (say running a batch process that accesses a lot of data) it won't double.

Pervasive has a pvcapacity.log that shows each days peak sessions and data use (in he case of the cloud license).  When I look at ours, there are days of higher data use with fewer sessions than other days.

Wes

1 - 11 of 11