What about Sysdatabases?
An Informix newcomer asked whether there's a SQL script to create the sysdatabases table. Replies explained that sysdatabases is a system (SMI) table inside the sysmaster database, created automatically at server initialisation by the buildsmi script ($INFORMIXDIR/etc/buildsmi) — so no manual creation is normally needed. If it's missing, buildsmi failed (e.g. INFORMIXDIR/INFORMIXSERVER unset or dbaccess not in PATH; check online.log) and can be rerun. It's queried as sysmaster:sysdatabases from any logged database. The poster thanked the responders.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I am new to Informix but I do have reasonable knowledge about the informix DB family. Can you people please tell me about Sysdatabases, is there a SQL file that I can run and create this table. Please do take some time out of busy schedule and do give me a lead/direction to take. I would really appreciate any help. Regards, Allen The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Hi,
Sysdatabases is a system table in the sysmaster db. It is automatically
created and there is no need to set it up manually.
If this does not exist, the buildsmi script did not execute on system
initialisation.
You should see a note in online.log. This is mainly because you did not
set INFORMIXSERVER/INFORMIXDIR before initialisation or dbaccess was not
in PATH.
You can execute buildsmi for yourself afterwards (I think as user
informix, but better consult the manual).
Marcus
-----Original Message-----
From: allen.philip@wipro.com [mailto:allen.philip@wipro.com]
Sent: Tuesday, April 10, 2007 11:24 AM
To: ids@iiug.org
Subject: What about Sysdatabases? [8790]
Hi,
I am new to Informix but I do have reasonable knowledge about the
informix DB family.
Can you people please tell me about Sysdatabases, is there a SQL file
that I can run and create this table.
Please do take some time out of busy schedule and do give me a
lead/direction to take.
I would really appreciate any help.
Regards,
Allen
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
www.wipro.com
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Group, How do I create Sysdatabases? Can someone please, give me the SQL file for the same and tell me how to run the query. It is naïve but is also necessary for the moment! Regards, Allen -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of allen.philip@wipro.com Sent: Tuesday, April 10, 2007 2:54 PM To: ids@iiug.org Subject: What about Sysdatabases? [8790] Hi, I am new to Informix but I do have reasonable knowledge about the informix DB family. Can you people please tell me about Sysdatabases, is there a SQL file that I can run and create this table. Please do take some time out of busy schedule and do give me a lead/direction to take. I would really appreciate any help. Regards, Allen The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Take a look at $INFORMIXDIR/etc/buildsmi ----- Original Message ---- From: "allen.philip@wipro.com" <allen.philip@wipro.com> To: ids@iiug.org Sent: Tuesday, April 10, 2007 12:27:42 PM Subject: RE: What about Sysdatabases? [8809] Hi Group, How do I create Sysdatabases? Can someone please, give me the SQL file for the same and tell me how to run the query. It is naïve but is also necessary for the moment! Regards, Allen -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of allen.philip@wipro.com Sent: Tuesday, April 10, 2007 2:54 PM To: ids@iiug.org Subject: What about Sysdatabases? [8790] Hi, I am new to Informix but I do have reasonable knowledge about the informix DB family. Can you people please tell me about Sysdatabases, is there a SQL file that I can run and create this table. Please do take some time out of busy schedule and do give me a lead/direction to take. I would really appreciate any help. Regards, Allen The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Redden, Thanks. Regards, Allen -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DL Redden Sent: Wednesday, April 11, 2007 12:16 AM To: ids@iiug.org Subject: Re: What about Sysdatabases? [8810] Take a look at $INFORMIXDIR/etc/buildsmi ----- Original Message ---- From: "allen.philip@wipro.com" <allen.philip@wipro.com> To: ids@iiug.org Sent: Tuesday, April 10, 2007 12:27:42 PM Subject: RE: What about Sysdatabases? [8809] Hi Group, How do I create Sysdatabases? Can someone please, give me the SQL file for the same and tell me how to run the query. It is naïve but is also necessary for the moment! Regards, Allen -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of allen.philip@wipro.com Sent: Tuesday, April 10, 2007 2:54 PM To: ids@iiug.org Subject: What about Sysdatabases? [8790] Hi, I am new to Informix but I do have reasonable knowledge about the informix DB family. Can you people please tell me about Sysdatabases, is there a SQL file that I can run and create this table. Please do take some time out of busy schedule and do give me a lead/direction to take. I would really appreciate any help. Regards, Allen The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Sysdatabases is in the System Management Interface (SMI) database, sysmaster. You can access it while connected to any logged database (access while attached to a non-logged database is not permitted) as sysmaster:sysdatabases or by connecting directly to sysmaster. Art S. Kagel ----- Original Message ----- From: Allen.Philip@Wipro.Com <ids@iiug.org> At: 4/10 13:28:20 Hi Group, How do I create Sysdatabases? Can someone please, give me the SQL file for the same and tell me how to run the query. It is na ve but is also necessary for the moment! Regards, Allen -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of allen.philip@wipro.com Sent: Tuesday, April 10, 2007 2:54 PM To: ids@iiug.org Subject: What about Sysdatabases? [8790] Hi, I am new to Informix but I do have reasonable knowledge about the informix DB family. Can you people please tell me about Sysdatabases, is there a SQL file that I can run and create this table. Please do take some time out of busy schedule and do give me a lead/direction to take. I would really appreciate any help. Regards, Allen The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.