Search found 68 matches

by timclark2000
Mon Aug 11, 2014 6:26 pm
Forum: New Toolkit
Topic: Poor PHP/Toolkit performance the first time
Replies: 3
Views: 2854

Re: Poor PHP/Toolkit performance the first time

Hi Richard, Have you narrowed down where precisely the different execution times are coming from? Off the top of my head, it sounds like the performance difference could be due to the SQL query processing rather than the middleware (toolkit/PHP). There are a number of SQL-related factors that could ...
by timclark2000
Wed Mar 05, 2014 9:50 pm
Forum: Zend Server for IBM i
Topic: Foreign Key Support
Replies: 4
Views: 2001

Re: Foreign Key Support

I tried your recreate with ON UPDATE RESTRICT and found that the error is different (155 instead of 150). If this is true for you, then you have probably run into a different problem, one that is fixed in the source code (see 2012-11-07 patch at http://174.79.32.155/wiki/pmwiki.php/MySql/DB2StorageE...
by timclark2000
Wed Mar 05, 2014 4:06 am
Forum: Zend Server for IBM i
Topic: Foreign Key Support
Replies: 4
Views: 2001

Re: Foreign Key Support

Because DB2 for IBM i does not support ON UPDATE CASCADE constraints, the IBMDB2I storage engine cannot support them either. IBMDB2I uses the built-in constraint support of DB2.

See http://pic.dhe.ibm.com/infocenter/iseri ... icmain.htm for info about the DB2 support.
by timclark2000
Sat Mar 01, 2014 1:04 am
Forum: Zend Server for IBM i
Topic: Multiple Instances of MYSQL on IBM
Replies: 1
Views: 1196

Re: Multiple Instances of MYSQL on IBM

Multiple instances of MySQL need distinct port numbers (this is true on any platform that runs MySQL.) So the direct answer to your final question would be "No." Now if you have control over the naming of schemas, you could possibly run a single instance of MySQL where each school gets its own set o...
by timclark2000
Tue Feb 18, 2014 7:01 pm
Forum: Zend Server for IBM i
Topic: Existing DB2 tables on MySQL
Replies: 5
Views: 2382

Re: Existing DB2 tables on MySQL

Assuming that your MySQL server is relatively quiet, you can look for QSQSRVR jobs that have the Current User set to the same profile as that which was used to start the MySQL server daemon. In the joblog for these jobs, you may be able to find a message that corresponds to the 2102 error. I can't t...
by timclark2000
Tue Feb 18, 2014 3:45 pm
Forum: Zend Server for IBM i
Topic: Existing DB2 tables on MySQL
Replies: 5
Views: 2382

Re: Existing DB2 tables on MySQL

I created a DB2 table using the definition you provided. I was then able to "discover" it and query it with MySQL following the steps in the YiPS document. I'm guessing there's additional complexity (indexes?, constraints?) in your case, but the table definition by itself doesn't seem to present a p...
by timclark2000
Mon Feb 17, 2014 3:27 pm
Forum: Zend Server for IBM i
Topic: Existing DB2 tables on MySQL
Replies: 5
Views: 2382

Re: Existing DB2 tables on MySQL

This could be a problem that was found and fixed in IBM i 7.1 with PTF SI50864. Cover letter description: Attempting to use an IBMDB2I table from within MySQL may generate a MySQL error message and fail. The MySQL error message may look like "Got error 2021 'See message MCH1201 [or MCH3601] in joblo...
by timclark2000
Wed Dec 04, 2013 5:50 pm
Forum: Zend Server for IBM i
Topic: MCH3601 SQL0901 errors on Zend 6 after Group PTF Applied
Replies: 8
Views: 4632

Re: MCH3601 SQL0901 errors on Zend 6 after Group PTF Applied

You don't say which program is sending the MCH3601, but taken together with the SQL0901, I would presume that it is coming from system code. If that is the case, then this definitely is a problem that IBM Support should evaluate. When discussing this with support, I would make it clear that you are ...
by timclark2000
Mon Aug 12, 2013 4:26 pm
Forum: Zend Server for IBM i
Topic: mysql folder is "Symbolic link"?
Replies: 6
Views: 2951

Re: mysql folder is "Symbolic link"?

I'm not sure how /mysql was created since it seems from the other evidence that Zend DBi/MySQL was never installed. However, you can remove the symbolic link easily by going into QShell and doing a rm /mysql (This is safe to do because rm will only remove the symbolic link, not everything pointed to...
by timclark2000
Mon Aug 05, 2013 6:03 pm
Forum: Zend Server for IBM i
Topic: mysql folder is "Symbolic link"?
Replies: 6
Views: 2951

Re: mysql folder is "Symbolic link"?

Perhaps something has changed recently, but in my experience Zend DBi (i.e. MySQL) is usually installed in /usr/local/mysql. So I'm a bit confused as to why you'd be getting anything in /mysql. If you go to QSHELL (via QSH at a green screen), what do you see if you run: ls -ld /mysql ls -l /usr/loca...