Informix database access from the PC - I/O issue
Posted in 1998
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
--openmail-part-00a74e73-00000001 Content-Type: multipart/alternative; boundary=openmail-part-00a74e73-00000002 --openmail-part-00a74e73-00000002 Content-Type: text/plain; charset=ISO-8859-1; name="BDY.RTF" Content-Disposition: inline; filename="BDY.RTF" Content-Transfer-Encoding: quoted-printable Got the ODBC driver from Informix 2.80 32 bit and also for laughs Intersolv 3.01 32 bit. Compiled the lastest prod Perl , DBI and DBD::ODBC modules and got connected to the database :-) However, I have the following question. Every time I go to access the database and read entries from a table the disk on the PC starts grinding, (it works, but seems IO bound on the= PC side) Is there something I have overlooked on the configuration ? Cheers Robin BAPCO - BellSouth Advertising and Publishing =2D----Original Message----- From: RVASUDEV =20 Sent: Saturday, May 23, 1998 6:27 PM To: informix-list Cc: RVASUDEV Subject: Re: Informix database access from a PC using Perl/DBD =20 Hi, =20 ( What is DBD ? ) =20 You need to have the ODBC s/w (driver manager and an Informix-specific ODBC driver) installed on your PC, along with the Perl-for-Win32 ODBC module. Check out the CPAN (Comprehensive Perl Archive Network) at www.perl.com or www.perl.org for info on where to get the Perl module and search for ODBC on the Web to get addressses of Informix-ODBC vendors (try Intersolv, they make a lot of ODBD drivers). =20 Vasudev Ram Infosys Technologies Ltd. Pune, India ______________________________ Reply Separator _________________________________ Subject: Informix database access from a PC using Perl/DBD Author: Levine.Robin@bapco.bls.com at smtp_gw Date: 5/22/98 1:35 PM We have the following setup here: Informix Online Server running on serveral UNIX boxes. =20 We would like to access the database from a PC using Perl and DBD. =20 What programs are needed on the PC so that one can use Perl and DBD =20 Thanks; Robin S Levine Levine.Robin@bapco.bls.com --openmail-part-00a74e73-00000002 Content-Type: application/rtf; name="BDY.RTF" Content-Disposition: attachment; filename="BDY.RTF" Content-Transfer-Encoding: base64 e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1 NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwXGNmMCBccGFyDQpHb3Qg dGhlIE9EQkMgZHJpdmVyIGZyb20gSW5mb3JtaXggMi44MCAzMiBiaXQgYW5kIGFsc28gZm9y IGxhdWdoc1xwYXINCkludGVyc29sdiAzLjAxIDMyIGJpdC5ccGFyDQpccGFyDQpDb21waWxl ZCB0aGUgbGFzdGVzdCBwcm9kIFBlcmwgLCBEQkkgYW5kIERCRDo6T0RCQyBtb2R1bGVzIGFu ZFxwYXINCmdvdCBjb25uZWN0ZWQgdG8gdGhlIGRhdGFiYXNlIDotKVxwYXINClxwYXINCkhv d2V2ZXIsIEkgaGF2ZSB0aGUgZm9sbG93aW5nIHF1ZXN0aW9uLlxwYXINClxwYXINCkV2ZXJ5 IHRpbWUgSSBnbyB0byBhY2Nlc3MgdGhlIGRhdGFiYXNlIGFuZCByZWFkIGVudHJpZXMgZnJv bSBhIHRhYmxlXHBhcg0KdGhlIGRpc2sgb24gdGhlIFBDIHN0YXJ0cyBncmluZGluZywgKGl0 IHdvcmtzLCBidXQgc2VlbXMgSU8gYm91bmQgb24gdGhlIFBDIHNpZGUpXHBhcg0KXHBhcg0K SXMgdGhlcmUgc29tZXRoaW5nIEkgaGF2ZSBvdmVybG9va2VkIG9uIHRoZSBjb25maWd1cmF0 aW9uID9ccGFyDQpccGFyDQpDaGVlcnNccGFyDQpSb2JpblxwYXINCkJBUENPIC0gQmVsbFNv dXRoIEFkdmVydGlzaW5nIGFuZCBQdWJsaXNoaW5nXHBhcg0KXHBhcg0KLS0tLS1PcmlnaW5h bCBNZXNzYWdlLS0tLS1ccGFyDQpGcm9tOiBSVkFTVURFViBccGFyDQpTZW50OiBTYXR1cmRh eSwgTWF5IDIzLCAxOTk4IDY6MjcgUE1ccGFyDQpUbzogaW5mb3JtaXgtbGlzdFxwYXINCkNj OiBSVkFTVURFVlxwYXINClN1YmplY3Q6IFJlOiBJbmZvcm1peCBkYXRhYmFzZSBhY2Nlc3Mg ZnJvbSBhIFBDIHVzaW5nIFBlcmwvREJEXHBhcg0KXHBhcg0KXHBhcg0KICAgICBccGFyDQog ICAgIEhpLFxwYXINCiAgICAgXHBhcg0KICAgICAoIFdoYXQgaXMgREJEID8gKVxwYXINCiAg ICAgXHBhcg0KICAgICBZb3UgbmVlZCB0byBoYXZlIHRoZSBPREJDIHMvdyAoZHJpdmVyIG1h bmFnZXIgYW5kIGFuIEluZm9ybWl4LXNwZWNpZmljXHBhcg0KICAgICBPREJDIGRyaXZlcikg aW5zdGFsbGVkIG9uIHlvdXIgUEMsIGFsb25nIHdpdGggdGhlIFBlcmwtZm9yLVdpbjMyIE9E QkNccGFyDQogICAgIG1vZHVsZS4gQ2hlY2sgb3V0IHRoZSBDUEFOIChDb21wcmVoZW5zaXZl IFBlcmwgQXJjaGl2ZSBOZXR3b3JrKVxwYXINCiAgICAgYXQgd3d3LnBlcmwuY29tIG9yIHd3 dy5wZXJsLm9yZyBmb3IgaW5mbyBvbiB3aGVyZSB0byBnZXQgdGhlXHBhcg0KICAgICBQZXJs IG1vZHVsZSBhbmQgc2VhcmNoIGZvciBPREJDIG9uIHRoZSBXZWIgdG8gZ2V0IGFkZHJlc3Nz ZXMgb2ZccGFyDQogICAgIEluZm9ybWl4LU9EQkMgdmVuZG9ycyAodHJ5IEludGVyc29sdiwg dGhleSBtYWtlIGEgbG90IG9mIE9EQkRccGFyDQogICAgIGRyaXZlcnMpLlxwYXINCiAgICAg XHBhcg0KICAgICBWYXN1ZGV2IFJhbVxwYXINCiAgICAgSW5mb3N5cyBUZWNobm9sb2dpZXMg THRkLlxwYXINCiAgICAgUHVuZSwgSW5kaWFccGFyDQpccGFyDQpfX19fX19fX19fX19fX19f X19fX19fX19fX19fX18gUmVwbHkgU2VwYXJhdG9yIF9fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX1xwYXINClN1YmplY3Q6IEluZm9ybWl4IGRhdGFiYXNlIGFjY2VzcyBmcm9t IGEgUEMgdXNpbmcgUGVybC9EQkRccGFyDQpBdXRob3I6ICBMZXZpbmUuUm9iaW5AYmFwY28u YmxzLmNvbSBhdCBzbXRwX2d3XHBhcg0KRGF0ZTogICAgNS8yMi85OCAxOjM1IFBNXHBhcg0K XHBhcg0KXHBhcg0KV2UgaGF2ZSB0aGUgZm9sbG93aW5nIHNldHVwIGhlcmU6XHBhcg0KICAg IEluZm9ybWl4IE9ubGluZSBTZXJ2ZXIgcnVubmluZyBvbiBzZXJ2ZXJhbCBVTklYIGJveGVz LlxwYXINCiAgICAgXHBhcg0KV2Ugd291bGQgbGlrZSB0byBhY2Nlc3MgdGhlIGRhdGFiYXNl IGZyb20gYSBQQyB1c2luZyBQZXJsIGFuZCBEQkQuXHBhcg0KICAgICBccGFyDQpXaGF0IHBy b2dyYW1zIGFyZSBuZWVkZWQgb24gdGhlIFBDIHNvIHRoYXQgb25lIGNhbiB1c2UgUGVybCBh bmQgREJEXHBhcg0KICAgICBccGFyDQpUaGFua3M7XHBhcg0KUm9iaW4gUyBMZXZpbmVccGFy DQpMZXZpbmUuUm9iaW5AYmFwY28uYmxzLmNvbVxwYXINCn0= --openmail-part-00a74e73-00000002-- --openmail-part-00a74e73-00000001 --openmail-part-00a74e73-00000001--