SAP Sybase IQ 15.4 manuals fixed to work with tablet/phone PDF readers like Aldiko

Aldiko Book Reader Premium Full v2.2.3.apkMany PDF readers for smart phones (Android/iphone) and tablets manage the pdf files Calibre_Logobased solely on the Title and Author fields in the PDF file. While for this is fine for your average book, it is not all that helpful with manuals that tend to have abbreviated or no data in the title/author fields. In the case of the manuals for Sybase IQ, I’m unable to load the manuals for say v15.4 and v16.0 as they have the same Title/Author data.

How to fix? Easy. Go get Calibre. Drop the PDF files on to the running Calibre. Edit them by hitting the E key.

In my case, I edited the “Title”, “Author”, “Tags”, “Publisher” and “Languages”:


Calibre doesn’t modify the PDF files themselves so I will need to export the files to a custom directory. In Calibre nomenclature, this is “Saving”. Highlight all the titles you want to export and hit “S” twice. Why twice? No idea. Choose the directory.

You can now copy the exported PDF files to your phone, tablet, whatever without fear of the v16.0 version of the P&T Guide being rejected by Aldiko because the v15.4 version is already added.

Here are the IQ v15.4 manuals that I’ve ‘fixed’ to work with Aldiko. They are identical to the PDFs on sybooks with the exception of the PDF fields I mentioned previously. No copyright infringement is intended. SAP/Sybase, please feel free to take these and host them.

IQ 15.4 Using Sybase IQ Multiplex – Sybase, Inc_

IQ 15.4 Time Series Guide – Sybase, Inc_

IQ 15.4 Sybase IQ Quick Start UNIX Linux – Sybase, Inc_


IQ 15.4 Installation and Configuration Guide for Linux – Sybase, Inc_

IQ 15.4 Guide to Licensed Options – Sybase, Inc_

IQ 15.4 Utility Guide – Sybase, Inc_

IQ 15.4 User-Defined Functions – Sybase, Inc_

IQ 15.4 Unstructured Data Analytics in Sybase IQ – Sybase, Inc_

IQ 15.4 Reference_ Statements and Options – Sybase, Inc_

IQ 15.4 Reference_ Building Blocks, Tables, and Procedures – Sybase, Inc_

IQ 15.4 System Administration Guide_ Volume 2 – Sybase, Inc_

IQ 15.4 System Administration Guide_ Volume 1 – Sybase, Inc_

IQ 15.4 Performance and Tuning Guide – Sybase, Inc_

IQ 15.4 Introduction to Sybase IQ – Sybase, Inc_

IQ 15.4 Advanced Security in Sybase IQ – Sybase, Inc_

IQ 15.4 Release Bulletin for Linux – Sybase, Inc_

Share Button


William Blunn wrote a good article on DBIx::MultiRow.

A requirement arises in many systems to update multiple SQL database rows. For small numbers of rows requiring updates, it can be adequate to use an UPDATE statement for each row that requires an update. But if there are a large number of rows that require an update, then the overhead of issuing large numbers of UPDATE statements can result in the operation as a whole taking a long time to complete.

Go to William Blunn’s blog to read the blog post 🙂

He will be adding the Perl module to CPAN soon.

Share Button

FW: Timm Murray’s Underappreciated Perl Modules Series: File::ShareDir

Problem: you have some wumpus-cavekind of data that needs to be distributed with your Perl module. Where do you put it in a cross-platform way?

Solution #1: Put it in a giant datastructure inside some module. This ends up with a big .pm file that chews up memory.

Solution #2: Put it in a __DATA__ section. But you only get one of those per module, and binary data might get hairy.

Best solution: File::ShareDir.

Read more on Timm Murray’s blog

Share Button

HowTo: Plex Home Theatre (Plex client) for Ubuntu Linux!

Installing Plex Home Theater in Ubuntu (or related distributions) is quite easy but it isn’t documented all that well.

sudo add-apt-repository ppa:plexapp/plexht
sudo add-apt-repository ppa:jon-severinsson/ffmpeg 
sudo add-apt-repository ppa:pulse-eight/libcec
sudo apt-get update
sudo apt-get install plexhometheater

You will find it in your desktop menu or you can call it directly:


Plex Home Theater

Share Button

HOWTO: Linux Samba protocol negotiation failed: NT_STATUS_INSUFFICIENT_RESOURCES – SOLVED! Windows XP 2k8 Win7 Win8 Win2012

The issue is the LanmanServer service runs out of memory. We need to boost that up:

On your Windows machine, fire up regedit (Start -> regedit) modify the following registry keys:
HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache” from 0 to 1
HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\Size” from 1 to 3

The problem seems to manifest itself more frequently if you use your Windows box as a file server or a media server. If you can, restart the Windows box. If for some reason you can’t (e.g. your significant other is watching a video on the tv streaming from your Windows box), then you can do effectively the same by restarting the following services:

(Start -> cmd.exe) as administrator
>net stop LanmanServer /y
> net start LanmanServer
> net start Browser
> net start HomeGroupListener

Share Button

Confused by SAP Sybase ASE’s new versioning system?

SAP Sybase recently changed their versioning system from 15.7 ESD 4 to 15.7 SP100, SP102 and 15.7 SP50. One would assume that since 100 is greater than 50 SP100 is newer than SP50. Not so. Not by a long shot.


SP50/60/XX – bug fixes ONLY from the 15.7 ESD 4.2 code line
SP100/102/XXX – bug fixes AND new features starting at the 15.7 ESD 4.2 code line

Why SAP would do this and neglect to provide adequate documentation ANYWHERE that explains the numbering is one of the great mysteries of SAP.

EBF 21517: 15.7 SP102 – 64 Bit  15.7 26 Jul 2013 EBF/Patch
EBF 21202: 15.7 SP50 – 64 Bit  15.7 23 Jul 2013 EBF/Patch


Share Button