Search found 13 matches

by wesl67
Thu Jan 03, 2019 11:03 pm
Forum: Zend Server for IBM i
Topic: ZendDBi (Maria 10.1) on IBMi crashes when creating tables
Replies: 4
Views: 445

Re: ZendDBi (Maria 10.1) on IBMi crashes when creating tables

Interesting I do have a user named 'DUMMY' on the system. I will have to try creating a new schema later.
by wesl67
Wed Jan 02, 2019 11:09 pm
Forum: Zend Server for IBM i
Topic: ZendDBi (Maria 10.1) on IBMi crashes when creating tables
Replies: 4
Views: 445

Re: ZendDBi (Maria 10.1) on IBMi crashes when creating tables

That was a good thought but sadly all it says is 'ibmdb2i error 2021: See message in joblog for job //.'
by wesl67
Thu Dec 20, 2018 8:34 pm
Forum: Zend Server for IBM i
Topic: ZendDBi (Maria 10.1) on IBMi crashes when creating tables
Replies: 4
Views: 445

ZendDBi (Maria 10.1) on IBMi crashes when creating tables

We have installed the ZendDBi 10.1 on our iSeries. I'm able to login to the server from mysql workbench and I can create a table using the innodb driver. However when I attempt to create a table using the IBMDB2I driver I get the error: ERROR 2013: Lost connection to MySQL server during query Sure e...
by wesl67
Wed Nov 07, 2018 5:38 pm
Forum: Zend Server for IBM i
Topic: MariaDB Current State
Replies: 0
Views: 1188

MariaDB Current State

We currently run MySQL 5.1 with the ibmdb2i driver. I have a few questions about MariaDB. 1. Has the ibmdb2i driver been released? 2. Does the trick to get existing db2 table to show up in MySQL still work? This was originally published on the young i professionals website that seems to be down now....
by wesl67
Mon Jul 20, 2015 3:43 pm
Forum: Zend Core for i5/OS
Topic: IBMDB2I updates from DB2
Replies: 0
Views: 2692

IBMDB2I updates from DB2

I'm having an issue with updating tables from db2 not firing certain MySQL events. Here is a list I have so far: - Query Cache - Updates from iseries do not expire the query cache as they should. - See here: forums zend com/viewtopic.php?f=8&t=126613 - Replication - Updating a table from MySQL will ...
by wesl67
Mon Apr 20, 2015 9:30 pm
Forum: Zend Server
Topic: MySQL IBMDB2I Query Cache
Replies: 0
Views: 1181

MySQL IBMDB2I Query Cache

Is anyone having issues with the MySQL query cache on tables updated from DB2? Here is an issue that I'm seeing: CREATE TABLE Users(`id` int, `first_name` varchar(45), `last_name` varchar(45)); INSERT INTO Users(`id`, `first_name`, `last_name`) VALUES (1, 'John', 'Doh'); from MySQL: MySQL -> SELECT ...
by wesl67
Thu Sep 18, 2014 10:25 pm
Forum: Zend Server for IBM i
Topic: Segmentation fault error PDO Prepare Statement (PHP5.5)
Replies: 2
Views: 4090

Re: Segmentation fault error PDO Prepare Statement (PHP5.5)

We had a few issues with 64-bit ibm driver and php 5.4. We were not using Zend server for this project it was just ubuntu packaged php. I found that the solution was to upgrade to php 5.5.16. You can read a helpfull blog post here: onefinepub_com/2014/02/php-segfaults-pdo_odbc-64-bit-platforms/ whic...
by wesl67
Thu Mar 06, 2014 2:40 pm
Forum: Zend Server for IBM i
Topic: Foreign Key Support
Replies: 4
Views: 2567

Re: Foreign Key Support

The error changes for me as well. We are on version "Server version: 5.1.59 MySQL Community Server (GPL)" which is newer than the patches.
by wesl67
Wed Mar 05, 2014 2:31 pm
Forum: Zend Server for IBM i
Topic: Foreign Key Support
Replies: 4
Views: 2567

Re: Foreign Key Support

Thank you for the reply I changed that as a test to see if it would work. I have tried Restrict, Cascade and No Action and I get the same error message. Do you know of anyone who is using Foreign Keys with IBMDB2I?
by wesl67
Tue Mar 04, 2014 10:21 pm
Forum: Zend Server for IBM i
Topic: Foreign Key Support
Replies: 4
Views: 2567

Foreign Key Support

If I run the following: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf...