Clymans - Part 2

Sybase ASE last full database backup

2016-07-112016-07-14Kevin Clymans

It's always useful to know when your last full database backup was. One way of doing this is by checking in your backup server log file. Better and easier to script is by using DBCC inside your database. (more…)

Poormans Dedupe

2016-07-062016-07-14Kevin Clymans

Fancy file systems as ZFS or WAFL have dedupe options to reduce the diskspace of recurring files. These file systems look at each file and only keep one copy of the same file if the file is present in multiple folders. Most of these file systems keep huge tables in memory to speed up this process. (more…)

YUM: Find in which yum group a package belongs

2016-07-032016-06-30Kevin Clymans

I was looking for a way to identify in which yum package group a specific package belongs. This helps me filter out the less useful packages on Satellite 6 content views. This is a more simple method then I would like and doesn't work from inside a script but it does what it should yum groupinfo '*' | less +/package

Sybase Replicated database copy

2016-06-302016-06-30Kevin Clymans

Refreshing a Primary Database of a Replication setup into DEV/QA. When we load a replicated database into another ASE server, it will not jump online due to the secondary truncation point that was set in the source database. In other words after the load is completed, when you issue the online database command it will fail due to the secondary truncation point that was used by the replication agent. (more…)

Sybase SQSH

2016-06-292016-06-30Kevin Clymans

I'm not a big fan of the Sybase provided isql tool. I prefer the far better sqsh (pronounced skwish) replacement. it provides many features isql is lacking like searching through queries, using a ; to end a query and much better OS redirection of results. (more…)

Sybase ASE performance tuning

2016-06-272016-06-18Kevin Clymans

Check performance We can check the performance of the ASE engine by using the sp_sysmon procedure. This procedure will monitor the engine for the given time spew out a long report. This allows us to see our performance and adjust the engine where needed. Sometimes sp_sysmon gives a direct recommendation at the bottom which is always good to looking to. Of course it helps to start sp_sysmon when the database is under high load. Type Command Data cache sp_sysmon "00:05:00" , dcache; Procedure cache sp_sysmon "00:05:00" , pcache; Memory sp_sysm...

SnapRAID

2016-06-232016-06-23Kevin Clymans

If you are worried like me about data degradation on your document/archive NAS it might be worthwhile looking into SnapRAID. SnapRAID is a backup solution for disk arrays. It creates hashes on a extra disk to ensure data integrity and gives you a additional recover option for the failed array disk. As an extra benefit you can recover specific files from accidental deletion and verify the current data set. I am using this mostly for the last option because it gives a extra layer of safety on those important files I don't want to see get corrupted without taking a 1 on 1 backup. Let's have a ...

Sybase ASE logins migration between 15.0.2 and 15.7

2016-06-202016-06-20Kevin Clymans

When you migrate from ase 15.0.2 to 15.7 you will notice that the syslogins table structure has been changed. Due to this change we need to add some info to the user list when migration between 15.0.2 to 15.7 (more…)

Hello world!

2016-05-102022-10-05Kevin Clymans

I will be posting some random stuff here but primarily about tech stuff. Some Red Hat, Sybase, Microsoft, etc. Stay tuned while I work out the issues with the site.