Jason L. Froebe - Tech tips and How Tos for Fellow Techies

On my media server, I wanted to set up Perl’s CPAN but when I ran install Bundle::CPAN, I ctrl-c’d out of it when I noticed that bzip2 wasn’t installed.  Silly me.  Soon after I started receiving:
Can’t call method “value” on an undefined value at /usr/share/perl5/IO/Uncompress/RawInflate.pm
Reinstalling Perl and all the related ubuntu packages doesn’t fix it, [...]

The ASE 15 stored procedure sp_tables doesn’t work with SQL UDFs. sp_tables has the udfs coming back as system tables.
repro:
1) create a sql udf in a db
2) run sp_tables, you will see the UDF as a “SYSTEM TABLE”
DBADEV1.sybase_dba.1> sp_tables;
table_qualifier table_owner table_name table_type remarks
————— ———– ———- ———- [...]

If you’re like me, you’ve run into lots of different issues with the Sybase ASE DBMS over the years. Today, Drew Montgomery looked at what happens when the 12.5.x -> 12.5.4 upgrade goes bad:
If you receive the 8419 error on sysusers after applying ASE 12.5.4 (or any other upgrade for that matter) such [...]

For those of us that use Sybase’s Replication Server, we have long ago been pacified into believing that there really isn’t much that can be done with Replication Server’s quirks but to endure them.
In today’s edition of the Sybase RepServer Quirks we take a look at the “out of mutexes” error.  A mutex is an [...]

Did you ever receive the error 17283 “Procedure ’sp_extendsegment’, Line 182 ‘tempdev1′ is reserved exclusively as a log device.” error? You can get the 17283 error when there is a device fragment that contains only the log segment. Part of the problem is when you extend the log segment onto a device, [...]