{"id":2046,"date":"2018-08-22T08:24:57","date_gmt":"2018-08-22T08:24:57","guid":{"rendered":"http:\/\/dbtut.com\/?p=2046"},"modified":"2018-12-06T13:31:06","modified_gmt":"2018-12-06T13:31:06","slug":"sybase-iq-architecture","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/","title":{"rendered":"Sybase IQ Architecture"},"content":{"rendered":"
<\/header>\n
\n

 <\/p>\n

Single Node Architecture:<\/h3>\n

when we talk about Sybase IQ architecture , We should explain about the Three\u00a0important IQ stores and three main files. which plays a vital role in Sybase IQ server.<\/p>\n

1)\u00a0Catalog Store<\/strong>
\n\u2013> Stores Metadata in system tables that is needed to run the database.
\n\u2013> Catalog Store is always recommended to create on a file system
\n\u2013> Physical Name : dbname.db
\n\u2013> Logical Name : SYSTEM
\n\u2013> Catalog Store has a separate transaction log file. Physical file name of the transaction log is dbname.log<\/p>\n

2) IQ store<\/strong>
\n\u2013> Stores User data as compressed indexes on the disk
\n\u2013> Logical Name : IQ_SYSTEM_MAIN for the first\/default dbspace of the IQ store. After that we can add as many dbspaces as we want that depends on the space requirement..
\n\u2013> Physical Name : dbname.iq
\n\u2013>IQ_SYSTEM_MAIN contains necessary information to open the database , IQ checkpoint,info about rollback\/rollforward , backup related metadata. So it is suggested not to create user tables on this dbspace , instead create new \u00a0IQ_USER_MAIN dbspace and use it for user data.<\/p>\n

3) IQ temporary Store<\/strong>
\n\u2013> acts like a tempdb in ASE . work area for sorting and grouping
\n\u2013> Physical Name : dbname.iqtmp
\n\u2013> Logical Name : IQ_SYSTEM_TEMP is the default dbspace .Depends on the space requirement we can add number of dbspaces.<\/p>\n

 <\/p>\n

Important Server Files<\/strong><\/p>\n

1)\u00a0IQ Message Log<\/strong>
\n\u2013>This is the IQ servers main log where all the important messages to monitor are logged
\neg: \u2013 Insert & delete Messages , Error Messages, query plans , status messages.
\n\u2013> physical file name : dbname.iqmsg<\/p>\n

2)\u00a0Catalog Store transaction log<\/strong>
\n\u2013> this file is the transaction log for the catalog store .
\n\u2013> physical file name : dbname.log<\/p>\n

3)\u00a0IQ server logs<\/strong>
\n\u2013> They are created each time IQ servers is started and logs the startup server log information .<\/p>\n

Dbspace :<\/strong><\/p>\n

\u2013>dbspace is like a device in Sybase ASE . Here in IQ we create \/ extend \u00a0Store using dbspaces .
\n\u2013>dbspace may be a file system file or Raw partition .
\n\u2013>The IQ store , catalog store and IQ temporary store consists of Multiple dbspaces .<\/p>\n

SybaseIQ \u00a0Multiplex Architecture
\n<\/strong>
\nSybase Multiplex , the name indicates that it has more than one node , may be 2 or 3, or 4 depends on the project requirements .<\/p>\n

Types of servers in a multiplex \u00a0or role of each server in a Multiplex :<\/p>\n

    \n
  1. \u00a0Coordinator<\/li>\n
  2. \u00a0Writer<\/li>\n
  3. Readers<\/li>\n<\/ol>\n

    Short Notes on Multiple server roles :<\/p>\n

    Coordinator Node<\/strong>
    \n\u2013>Each multiplex configuration has one and only one coordinator node that is capable of readonly\u00a0and read-write operations and is also responsible for bookkeeping to manage other nodes.
    \n\u2013>When you convert an existing simplex server to multiplex, it becomes the coordinator node.<\/p>\n

    All nodes in a multiplex configuration are secondary nodes except the coordinator.
    \nSecondary nodes:Can be either read-only nodes (reader nodes) or read-write nodes (writer nodes).<\/p>\n

    Writer nodes:<\/strong>
    \nCan run read-only and read-write operations against shared IQ objects.
    \n\u2022 Can manipulate local data in temporary and SA base tables.<\/p>\n

    Reader nodes:<\/strong>
    \n\u2022 Can run read-only operations against shared IQ objects.
    \n\u2022 Can manipulate local data in temporary and SA base tables.<\/p>\n

    \u2013> Each server has its own catalog store, tempdb store and they all share IQ main Store .<\/p>\n\n<\/div>\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"excerpt":{"rendered":"

      Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three\u00a0important IQ stores and three main files. which plays a vital role in Sybase IQ server. 1)\u00a0Catalog Store \u2013> Stores Metadata in system tables that is needed to run the database. \u2013> Catalog Store is always recommended to …<\/p>\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"author":165,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1319],"tags":[],"class_list":["post-2046","post","type-post","status-publish","format-standard","","category-sybase"],"aioseo_notices":[],"yoast_head":"\nSybase IQ Architecture - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Sybase IQ Architecture\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sybase IQ Architecture - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Sybase IQ Architecture\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-22T08:24:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-06T13:31:06+00:00\" \/>\n<meta name=\"author\" content=\"Bhaskara Vasamsetti\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bhaskara Vasamsetti\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\"},\"author\":{\"name\":\"Bhaskara Vasamsetti\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/e8bbb588ad40d9e6599e198e5444d24c\"},\"headline\":\"Sybase IQ Architecture\",\"datePublished\":\"2018-08-22T08:24:57+00:00\",\"dateModified\":\"2018-12-06T13:31:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\"},\"wordCount\":534,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"Sybase\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\",\"name\":\"Sybase IQ Architecture - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-22T08:24:57+00:00\",\"dateModified\":\"2018-12-06T13:31:06+00:00\",\"description\":\"Sybase IQ Architecture\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sybase IQ Architecture\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/e8bbb588ad40d9e6599e198e5444d24c\",\"name\":\"Bhaskara Vasamsetti\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41c21bc0cb53e2561f55ce030ff954bbb475f1a56baf2c1d7b3af3a3b32146f2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41c21bc0cb53e2561f55ce030ff954bbb475f1a56baf2c1d7b3af3a3b32146f2?s=96&d=mm&r=g\",\"caption\":\"Bhaskara Vasamsetti\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bhaskaravasamsetti\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sybase IQ Architecture - Database Tutorials","description":"Sybase IQ Architecture","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/","og_locale":"en_US","og_type":"article","og_title":"Sybase IQ Architecture - Database Tutorials","og_description":"Sybase IQ Architecture","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-22T08:24:57+00:00","article_modified_time":"2018-12-06T13:31:06+00:00","author":"Bhaskara Vasamsetti","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bhaskara Vasamsetti","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/"},"author":{"name":"Bhaskara Vasamsetti","@id":"https:\/\/dbtut.com\/#\/schema\/person\/e8bbb588ad40d9e6599e198e5444d24c"},"headline":"Sybase IQ Architecture","datePublished":"2018-08-22T08:24:57+00:00","dateModified":"2018-12-06T13:31:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/"},"wordCount":534,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["Sybase"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/","name":"Sybase IQ Architecture - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-22T08:24:57+00:00","dateModified":"2018-12-06T13:31:06+00:00","description":"Sybase IQ Architecture","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/sybase-iq-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Sybase IQ Architecture"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/e8bbb588ad40d9e6599e198e5444d24c","name":"Bhaskara Vasamsetti","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/41c21bc0cb53e2561f55ce030ff954bbb475f1a56baf2c1d7b3af3a3b32146f2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41c21bc0cb53e2561f55ce030ff954bbb475f1a56baf2c1d7b3af3a3b32146f2?s=96&d=mm&r=g","caption":"Bhaskara Vasamsetti"},"url":"https:\/\/dbtut.com\/index.php\/author\/bhaskaravasamsetti\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2046","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/165"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2046"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2046\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}