http://www.sqls.net/wiki/ 2012-05-21T05:02:31-05:00 http://www.sqls.net/wiki/ http://www.sqls.net/wiki/lib/images/favicon.ico text/html 2012-05-08T09:53:05-05:00 bruce http://www.sqls.net/wiki/howto:connect_to_iseries_as_400_db_with_php_db2_connect_pe?rev=1336488785&do=diff This covers the installation of IBM DB2 Connect Personal Edition on Gentoo Linux and integration with PHP and Apache. IBM DB2 allows us to connect to our AS/400 JDE system and run SQL queries. Which we do so we can make pretty HTML reports for sales & management :) text/html 2012-04-11T09:39:10-05:00 bruce http://www.sqls.net/wiki/howto:elkm1?rev=1334155150&do=diff THIS PAGE HAS MOVED. PLEASE VISIT <http://bmts.us/wiki/doku.php?id=article:elkm1:rs232-eth> text/html 2012-01-05T16:45:55-05:00 bruce http://www.sqls.net/wiki/howto:log_squid_to_mysql?rev=1325803555&do=diff Introduction This will describe how to get all of the Squid access logs into mysql so you can run whatever reports you want off of them. I don't have time to really write this out nicely right now. But I plan to in the future. So far I just have a basic outline and it'll take a bucket of smarts and common sense to get something to work out of this. I do now have the script up for download which is really the key piece. There's 2-3 other ways of doing this and I plan to mention those as wel… text/html 2011-07-08T17:58:23-05:00 bruce http://www.sqls.net/wiki/start?rev=1310165903&do=diff I just migrated to DokuWiki.. Some stuff hasn't been edited to match the new format.. I'll get it fixed. I needed a place to put some HOW-TO's that I've wrote. I played with the idea of building a simple wiki parser for the main <http://sqls.net> site but that proved more trouble then it could be worth. So I've taken this route. I used MediaWiki for awhile but I got really tired of it's database errors and constant problems with people modifying my pages. So now I'm using DokuWiki. It wa… text/html 2011-06-21T16:50:31-05:00 bruce http://www.sqls.net/wiki/howto:understand_zdb_-s_or_-dd_output?rev=1308693031&do=diff So while learning about ZFS dedup and compression I came across the command zdb -DD which tells me about the dedup and compression ratios.. But I didn't really understand the output and couldn't find much info on the net to explain it. So.. Most of this is a wild ass guess.