Skip to main content

Run Unit tests using DBTest library

Sybase IQ columnar analytics database uses DBTest as Unit test library.
Following are the steps to use it:
$ cds
$ cd testlib
$ vi xyz.tst #Write the dbtest.
$ dbtest -y xyz.tst #Checks for syntax errors in the tst file.
$ vi my.bch #Enter in the first line "xyz.tst"
$ vi xyz.op #This is the output file whose contents are compared with the actual run-time output of the test.
$ cd ..
$ cmake debug64
$ cdp (test directory)
$ setup current debug64
$ -port xxxx -newdbonerror my.bch #This run the tests

If test fails then
$ vi xyz.ot #Check out the errors.
$ vi xyz.tst #Correct the errors and rerun the test.

Use dbtest command to run your tests:
  1. On terminal 1, run commands:
    $ setenv IQTMP `pwd`
    $ setenv IQTMP15 `pwd`
    $ setenv ASTMP `pwd`
    $ runsrv abc abcd.db, OR $iqsrv15 -n abc abcd.db -zr all -gd all -gl all -c 32m -ch 200m -x "tcpip(port=xxxx)"
  2. On terminal 2, run commands:
    $ setenv IQTMP `pwd`
    $ setenv IQTMP15 `pwd`
    $ setenv ASTMP `pwd`
    dbtest -ds -m1 xyz.tst > xyz.ot
  3. To connect to an IQ database server, either set environmental variables or specify following command in .tst file:
    stringconnect "uid=dba;pwd=sql;eng=abc;links=tcpip{host=m/cName;port=xxxx}"


Popular posts from this blog

MPlayer subtitle font problem in Windows

While playing a video with subtitles in mplayer, I was getting the following problem:
New_Face failed. Maybe the font path is wrong. Please supply the text font file (~/.mplayer/subfont.ttf).
Solution is as follows:
Right click on "My Computer".Select "Properties".Go to "Advanced" tab.Click on "Environment Variables".Delete "HOME" variable from User / System variables.

Procedure for name and date of birth change (Pune)

For change of name, the form (scribd) is available free of cost at Government Book Depot (Shaskiya Granthagar), which is located near Collector’s office, next to Saint Helena's School. The postal address is:
Government Photozinco Press Premises and Book Depot,
5, Photozinco Press Road, Pune, MH, 411001.
Wikimapia link

Charges for name or date of birth change, in the Maharashtra Government Gazette:
INR 120.00 per insertion (for two copies of the Gazette)
For backward class applicants: INR 60.00
Charges for extra copy of the Gazette: INR 15.00 per copy (two copies are enough, so you may not want to pay extra for extra copies).

Backward class applicants are required to submit a xerox of caste certificate of old name as issued by the Collector of the District concerned.

Once the form is duly submitted, it normally takes 10 to 15 days for publication of advertisement in the Maharashtra Government Gazette. The Gazette copy reaches to the address filled in the form within next 7 to 15 day…

Setting up ELK 5.x (ElasticSearch, Logstash, Kibana) cluster

We recently upgraded from ElasticSearch 2.4.3 to 5.6.2.
Below are the steps that we used to install and configure new ELK cluster.

ElasticSearchInstallationmkdir -p /work/elk/data/data-es562 mkdir -p /work/elk/data/logs-es562 mkdir -p /work/elk/data/repo-es562 cd /work/elk/ curl -O tar -zxvf elasticsearch-5.6.2.tar.gz curl -O cd /work/elk/elasticsearch-5.6.2 ./bin/elasticsearch-plugin install file:///work/elk/
Settings for Master + Ingest node in elasticsearch.ymlWe have reused master nodes as ingest nodes, because we don't have any heavy ingest pipelines, and x-pack monitoring requires at-least one ingest node to be present in the cluster. ESDev562 "master_01" node.master: true # Enable the node.master role (enabled by default). false # D…