informixs-technology.blogspot.com

Informix technology

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;. Every unfragmented/unp...

http://informixs-technology.blogspot.com/

OVERVIEW OF informixs-technology.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

4

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR INFORMIXS-TECHNOLOGY.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

July

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 16 reviews

5 star

5

4 star

6

3 star

4

2 star

0

1 star

1

Hey there! Start your review of informixs-technology.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT INFORMIXS-TECHNOLOGY.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

4

SSL

EXTERNAL LINKS

0

SITE IP

172.217.12.193

LOAD TIME

0.577 sec

SCORE

6.2

PAGE TITLE

Informix technology | informixs-technology.blogspot.com Reviews

<META> DESCRIPTION

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;. Every unfragmented/unp...

<META> KEYWORDS

1 informix technology

2 database sysadmin;

3 end foreach

4 end function;

5 posted by

6 dodong

7 no comments

8 informix administrators blog

9 original sql

10 changed sql

CONTENT

Page content here

KEYWORDS ON PAGE

informix technology,database sysadmin;,end foreach,end function;,posted by,dodong,no comments,informix administrators blog,original sql,changed sql,labels informix technology,blog archive

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Informix technology | informixs-technology.blogspot.com Reviews

https://informixs-technology.blogspot.com

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;. Every unfragmented/unp...

INTERNAL PAGES

informixs-technology.blogspot.com

1

Informix technology: January 2010

http://informixs-technology.blogspot.com/2010_01_01_archive.html

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;. Every unfragmented/unp...

2

Informix technology: DATABASE sysadmin;

http://informixs-technology.blogspot.com/2010/01/database-sysadmin.html

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;.

3

Informix technology: Informix Administrators Blog

http://informixs-technology.blogspot.com/2010/01/informix-administrators-blog.html

Monday, January 4, 2010. Every unfragmented/unpartitioned IDS Table can have a maximum of 16 Mio. pages.To exceed this limit the table can be fragmented / partitioned.Here is a example function/task for the IDS 11.X sysadmin database to check this limit.The function triggers a Serverity RED Warning event if page fillfactor = 98%, a Severity YELLOWWarning event if page fillfactor = 90% and a YELLOW Info event if page fillfactor = 70%. DROP FUNCTION check table pages1;. INSERT INTO ph task(tk name,tk type,...

4

Informix technology: Informix SQL (Use of Functions Cause Sequencial Scans)

http://informixs-technology.blogspot.com/2010/01/informix-sql-use-of-functions-cause.html

Monday, January 4, 2010. Informix SQL (Use of Functions Cause Sequencial Scans). I have saw many times at clients where SQL statements use "functions" in trying to simplify operations. Sometimes the way that functions are used can cause sequencial scans on tables. Here is an example where the function caused a sequencial scan. To resolve the issue we were able to remove the "UPPER" function since the application had always stored characters in upper case. From ps voucher srch vw. From ps voucher srch vw.

UPGRADE TO PREMIUM TO VIEW 0 MORE

TOTAL PAGES IN THIS WEBSITE

4

OTHER SITES

informixnotes.blogspot.com

Informix Notes

Thursday, June 2, 2011. IIUG Conference 2011 was the best! Start here for everything informix. Http:/ www.iiug.org. Monday, May 11, 2009. Informix 11.50 helpful links. Setup php/apache/pdo informix/ids to all work together. http:/ www.ibm.com/developerworks/data/library/techarticle/dm-0606bombardier/. Connection Manager Setup. http:/ publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp? Topic=/com.ibm.admin.doc/ids admin 1201.htm. Wednesday, April 30, 2008. This is looking like my once per year blog.

informixoncampus.blogspot.com

Informix on Campus

News and happenings of Informix on Campus all around the world. Tuesday, May 7, 2013. Informix on Campus - back online. I am happy to announce that the migration of the Informix on Campus wiki is complete and the site is back online! The URL has changed and so please update your bookmarks - https:/ www.ibm.com/developerworks/connect/informixoncampus. In a week or two, all the major search engines should have this wiki indexed. Do you think we can add something relevant to this wiki? Friday, April 19, 2013.

informixoncampus.org

Informixoncampus.org

The domain informixoncampus.org may be for sale. Click here to make an offer or call 877-588-1085 to speak with one of our domain experts. This domain may be for sale. Buy this Domain.

informixonline.blogspot.com

informix online

Полевые заметки о СУБД Informix. Понедельник, 27 августа 2012 г. При установке новой версии JDBC драйвера Informix может возникнуть проблема - не запускается инсталлятор. Если используется Java 7, то можно попробовать запустить инсталлятор в версии Java 6, поскольку версия 7 пока не поддерживается. Подробнее см. http:/ www.stuart-taylor.net/2011/12/ibm-informix-jdbc-driver-version-3-50-install-error-could-not-load-wizard-fixed/. У меня этот способ сработал при установке драйвера версии 3.50. В случае воз...

informixroundup.wordpress.com

IBM Informix Round-Up

Like us on facebook. Like us on facebook. Follow Blog via Email. Enter your email address to follow this blog and receive notifications of new posts by email. Join 4 other followers. IBM Informix Round-Up : April 2013. IBM Informix Round-Up : March 2013. IBM Informix Round-Up : February 2013. IBM Informix Round-Up : January 2013. May 2, 2013. By IBM Data Warehousing. Comments No Comments on IBM Informix Round-Up : April 2013. IBM Informix Round-Up : April 2013. A Message from your Informix Marketing Team.

informixs-technology.blogspot.com

Informix technology

Monday, January 4, 2010. DROP FUNCTION check table extent1;. CREATE FUNCTION check table extent1(task id INT, task seq INT) RETURNING INTEGERDEFINE database name CHAR(129);DEFINE table owner CHAR(33);DEFINE table name CHAR(129);DEFINE dbspace name CHAR(129);DEFINE next extent size INTEGER;DEFINE dbspace pages free INTEGER;. SELECT b.name dbspace, SUM(a.nfree) pagesfree FROM sysmaster:syschunks a, sysmaster:sysdbspaces b WHERE a.dbsnum = b.dbsnum GROUP BY 1 INTO TEMP t dbsp free 1;. Every unfragmented/unp...

informixsoftware.com

Informix Software IDS 12.1

Informix Quick Start Guide. Quick Start Guide for Client SDK. Backup and Restore Guide. Change Data Capture API Programmer's Guide. Client Products Installation Guide. Database Design and Implementation Guide. Database Extensions User's Guide. DataBlade API Function Reference. DataBlade API Programmer's Guide. DataBlade Developers Kit User's Guide. DataBlade Module Development Overview. DataBlade Module Installation and Registration Guide. Embedded SQLJ User's Guide. Error Messages (HTML only). Whether y...

informixsys.com.ar

Software para Concesionarios | Informix s&s

Informix s&s ofrece Software de gestión para concesionarios automotores, agrícolas y motovehículares. Su navegador está obsoleto! Por favor, actualice su navegador para continuar correctamente. Actualizar Navegador. Gestione su concesionario con eficiencia e inteligencia de negocios. Software de Gestión DMS flexible y escalable para administrar su empresa de manera integrada. Déjelo en buenas manos. Trayectoria y experiencia a su servicio. Únase a nuestra pasión. Ponemos todos nuestros esfuerzos en hacer...

informixtech.com

Home - Informix Technology

Domain & Hosting. Software QA And Testing. Pure Call Privacy Policy. Your Total IT Solution. More Avada Features To Love! Custom Logo and Favicon Support. Video Integration and Backgrounds. Self Hosted, YouTube and Vimeo. Sleek Fading Scrolling Effect. Intuitive Short Code Generator. Easy Installation and Setup. Built with HTML5 and CSS3. Light And Dark Color Schemes. Custom Google Map Styling. Retina Ready For HD Screens. Font Awesome Icon Set. Gravity Forms Style Support. Contact Form 7 Style Support.

informixuser.com

Washington Area Informix User Group -

Washington Area Informix User Group. WAIUG Meeting Mar 7th 2018. January 30, 2018. Mark your calendars and join us for the next meeting of the Washington Area Informix Users Group (WAIUG). Wed March 7th 2018, 8:30am – 1pm. Getting going with PSM and Informix 12 – Thomas Beebe. Also, join our HCL Informix professionals as they present the details on using the new Smart Triggers and share the new technologies found in Informix 12.10.xC10. Here are the details regarding our meeting. Bethesda, MD 20817.

informixuser.org

Washington Area Informix User Group -

Washington Area Informix User Group. WAIUG Meeting Mar 7th 2018. January 30, 2018. Mark your calendars and join us for the next meeting of the Washington Area Informix Users Group (WAIUG). Wed March 7th 2018, 8:30am – 1pm. Getting going with PSM and Informix 12 – Thomas Beebe. Also, join our HCL Informix professionals as they present the details on using the new Smart Triggers and share the new technologies found in Informix 12.10.xC10. Here are the details regarding our meeting. Bethesda, MD 20817.