Informix

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

Where can we find it?

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

FYI: In ratios.1170.sql a procedure is called rt() instead of ratios()

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

I modified ratios() for 11.70 to meet conditions of read-only replica.
The original procedure has aborted with a division-by-zero error.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

That one is really strange Dennis. The line in question is not defining/declaring malloc but rather defining __alloca to be replaced by malloc. The argument list should be correct anyway in the call at the top of exchange(). Maybe try removing the space between __alloca and the argument list, though that shouldn't make any differencce.

Why did you need to replace getopt.h with unistd.h? The getiopt.h header is included in the package. Which utility was compiling at this point?

Art

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

You have `#include <getopt.h>` in a couple of files. Below is my utils2_ak.patch file to apply against the source.

Before applying the patch I have to fix file permissions: `chmod 644 Makefile *.ec`

--- Makefile    2023-02-22 16:59:50.000000000 +0300
+++ Makefile.new        2023-12-07 12:08:29.000000000 +0300
@@ -5,7 +5,7 @@
  # If your copy of GNU make is not called 'make' or is not first in
  # your path set the variable MAKE appropriately so the recursive make
  # of myschema will use the correct version of make.
- MAKE=make
+ MAKE=/opt/freeware/bin/make

  .SUFFIXES:
  .SUFFIXES: .ec .c .o
@@ -91,12 +91,12 @@
  bload: ul
        -rm bload 2>/dev/null
        -ln ul bload
-       -touch -h bload
+       -touch bload

  bunload: ul
        -rm bunload 2>/dev/null
        -ln ul bunload
-       -touch -h bunload
+       -touch bunload

  printfreeB: printfreeB.ec
        INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $^
--- dbdelete.ec 2023-10-26 22:52:42.000000000 +0300
+++ dbdelete.ec.new     2023-12-07 12:09:04.000000000 +0300
@@ -83,7 +83,11 @@
  #include <string.h>
  #include <errno.h>
  #include <time.h>
+ #ifdef _AIX
+ #include <unistd.h>
+ #else
  #include <getopt.h>
+ #endif

  EXEC SQL include sqlca;
  EXEC SQL include sqlda;
--- dbping.ec   2021-12-21 20:12:53.000000000 +0300
+++ dbping.ec.new       2023-12-07 12:09:22.000000000 +0300
@@ -86,7 +86,11 @@
  #endif
  #include <time.h>
  #include <sys/time.h>
+ #ifdef _AIX
+ #include <unistd.h>
+ #else
  #include <getopt.h>
+ #endif
  #include <errno.h>

  #define SQLOK 0
--- myschema.d/myschema.mk      2023-11-24 16:55:31.000000000 +0300
+++ myschema.d/myschema.mk.new  2023-12-07 12:40:37.000000000 +0300
@@ -4,12 +4,12 @@
  SHELL=/usr/bin/ksh
  VPATH=.:./RCS

- LDFLAGS=                      # none needed on most systems
+ # LDFLAGS=                    # none needed on most systems
  # LDFLAGS=-static             # static libraries are not compatible under GCC v5 or later
  # LDFLAGS=-xarch=v9           # For Solaris 64bit versions
  # LDFLAGS=-q64                        # For AIX 64 bit mode using XLC
  # LDFLAGS=-q64 -static                # For AIX 64 bit mode & static link using XLC
- # LDFLAGS=-maix64             # For AIX 64 bit mode using GCC
+ LDFLAGS=-maix64               # For AIX 64 bit mode using GCC

  CFLAGS=$(CDFLAGS)
  # CFLAGS=$(CDFLAGS) -Ae               # For HP-32bit executables
@@ -20,10 +20,10 @@
  # ECFLAGS=$(CFLAGS) -EDbigint=int # For CSDK earlier than 3.50

  # CDFLAGS=-g
- CDFLAGS=-O3             # Mostly only for GCC
+ # CDFLAGS=-O3             # Mostly only for GCC
  # CDFLAGS=-O2 -qmaxmem=32768    # For AIX using XLC to improve optimization.
  # CDFLAGS=-O2 -qmaxmem=32768 -q64    # For AIX 64bit using XLC
- # CDFLAGS=-O3 -maix64 # For AIX 64bit using GCC
+ CDFLAGS=-O2 -maix64   # For AIX 64bit using GCC
  # CDFLAGS=-O            # For HP and other systems that do not have -O3
  # CDFLAGS=-Onolimit   # For myschema.ec only - the HP compiler complains that
  #                     # it does not have enough memory to optimize & suggests

That one is really strange Dennis. The line in question is not defining/declaring malloc but rather defining __alloca to be replaced by malloc. The argument list should be correct anyway in the call at the top of exchange(). Maybe try removing the space between __alloca and the argument list, though that shouldn't make any differencce.

Why did you need to replace getopt.h with unistd.h? The getiopt.h header is included in the package. Which utility was compiling at this point?

Art

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Dennis:

I'm aware that getopt.h is included in several places. The file is included in the distribution so I'm wondering why you ran into a need to use unistd.h instead? I may need to add a note about that in the Building file.

Art

Art,

You have `#include <getopt.h>` in a couple of files. Below is my utils2_ak.patch file to apply against the source.

Before applying the patch I have to fix file permissions: `chmod 644 Makefile *.ec`

--- Makefile    2023-02-22 16:59:50.000000000 +0300
+++ Makefile.new        2023-12-07 12:08:29.000000000 +0300
@@ -5,7 +5,7 @@
  # If your copy of GNU make is not called 'make' or is not first in
  # your path set the variable MAKE appropriately so the recursive make
  # of myschema will use the correct version of make.
- MAKE=make
+ MAKE=/opt/freeware/bin/make

  .SUFFIXES:
  .SUFFIXES: .ec .c .o
@@ -91,12 +91,12 @@
  bload: ul
        -rm bload 2>/dev/null
        -ln ul bload
-       -touch -h bload
+       -touch bload

  bunload: ul
        -rm bunload 2>/dev/null
        -ln ul bunload
-       -touch -h bunload
+       -touch bunload

  printfreeB: printfreeB.ec
        INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $^
--- dbdelete.ec 2023-10-26 22:52:42.000000000 +0300
+++ dbdelete.ec.new     2023-12-07 12:09:04.000000000 +0300
@@ -83,7 +83,11 @@
  #include <string.h>
  #include <errno.h>
  #include <time.h>
+ #ifdef _AIX
+ #include <unistd.h>
+ #else
  #include <getopt.h>
+ #endif

  EXEC SQL include sqlca;
  EXEC SQL include sqlda;
--- dbping.ec   2021-12-21 20:12:53.000000000 +0300
+++ dbping.ec.new       2023-12-07 12:09:22.000000000 +0300
@@ -86,7 +86,11 @@
  #endif
  #include <time.h>
  #include <sys/time.h>
+ #ifdef _AIX
+ #include <unistd.h>
+ #else
  #include <getopt.h>
+ #endif
  #include <errno.h>

  #define SQLOK 0
--- myschema.d/myschema.mk      2023-11-24 16:55:31.000000000 +0300
+++ myschema.d/myschema.mk.new  2023-12-07 12:40:37.000000000 +0300
@@ -4,12 +4,12 @@
  SHELL=/usr/bin/ksh
  VPATH=.:./RCS

- LDFLAGS=                      # none needed on most systems
+ # LDFLAGS=                    # none needed on most systems
  # LDFLAGS=-static             # static libraries are not compatible under GCC v5 or later
  # LDFLAGS=-xarch=v9           # For Solaris 64bit versions
  # LDFLAGS=-q64                        # For AIX 64 bit mode using XLC
  # LDFLAGS=-q64 -static                # For AIX 64 bit mode & static link using XLC
- # LDFLAGS=-maix64             # For AIX 64 bit mode using GCC
+ LDFLAGS=-maix64               # For AIX 64 bit mode using GCC

  CFLAGS=$(CDFLAGS)
  # CFLAGS=$(CDFLAGS) -Ae               # For HP-32bit executables
@@ -20,10 +20,10 @@
  # ECFLAGS=$(CFLAGS) -EDbigint=int # For CSDK earlier than 3.50

  # CDFLAGS=-g
- CDFLAGS=-O3             # Mostly only for GCC
+ # CDFLAGS=-O3             # Mostly only for GCC
  # CDFLAGS=-O2 -qmaxmem=32768    # For AIX using XLC to improve optimization.
  # CDFLAGS=-O2 -qmaxmem=32768 -q64    # For AIX 64bit using XLC
- # CDFLAGS=-O3 -maix64 # For AIX 64bit using GCC
+ CDFLAGS=-O2 -maix64   # For AIX 64bit using GCC
  # CDFLAGS=-O            # For HP and other systems that do not have -O3
  # CDFLAGS=-Onolimit   # For myschema.ec only - the HP compiler complains that
  #                     # it does not have enough memory to optimize & suggests

That one is really strange Dennis. The line in question is not defining/declaring malloc but rather defining __alloca to be replaced by malloc. The argument list should be correct anyway in the call at the top of exchange(). Maybe try removing the space between __alloca and the argument list, though that shouldn't make any differencce.

Why did you need to replace getopt.h with unistd.h? The getiopt.h header is included in the package. Which utility was compiling at this point?

Art

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

"The warnings you're encountering during the package build on AIX 7.1 with GNU make and gcc seem to be related to incompatible declarations with the 'malloc' function. It appears that there's an implicit declaration conflict within the 'getopt.c' file.

To address the warning regarding 'malloc', it might be helpful to review the 'getopt.c' file, particularly around line 106 where the 'malloc' function seems to be implicitly declared as '__alloca'. This could potentially conflict with the system's declaration of 'malloc'.

Regarding the replacement of '<getopt.h>' with '<unistd.h>', if your system requires this change, it's likely due to differences in header file structures or system-specific configurations. This might affect how certain functions or declarations are handled within your code.

To resolve these warnings, you may need to modify the 'getopt.c' file, ensuring proper declarations and include statements. Additionally, consider checking the codebase for any system-specific configurations or requirements for AIX 7.1, especially regarding memory allocation functions like 'malloc'."

Art,

Building the package on AIX 7.1 with GNU make and gcc I got the following warnings:

getopt.c: In function 'exchange':
getopt.c:106:27: warning: incompatible implicit declaration of built-in function 'malloc' [enabled by default]
   #define __alloca        malloc
                           ^
getopt.c:274:27: note: in expansion of macro '__alloca'
   char **temp = (char **) __alloca (nonopts_size);
                           ^

Also, I had to replace <getopt.h> with <unistd.h>.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Art,

On AIX 7.1, myschema fails with coredump on VIEWs:

Writing full schema DDL to:       stdout
Memory fault(coredump)

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

Dennis:

Would it be possible to compile it with -g and run it in a debugger to at least get me a location in the code where it is crapping out?

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Thu December 14, 2023 09:41 AM
From: Dennis Melnikov
Subject: Updated utils2_ak package available

Art,

On AIX 7.1, myschema fails with coredump on VIEWs:

Writing full schema DDL to:       stdout
Memory fault(coredump)

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Fri November 24, 2023 01:07 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Starting program: /home/denis/ArtKagel/utils2_ak/myschema -d eagle -t v_reestr_ord_k1
Writing full schema DDL to:       stdout

Program received signal SIGSEGV, Segmentation fault.
0x00000001001c5c84 in gettok2 () at tokens.c:135
135                 *delp = *pos;
(gdb) bt
#0  0x00000001001c5c84 in gettok2 () at tokens.c:135
#1  0x00000001001c3cd4 in print_views (tabid=2904, tabname=0x11006fff8 <systables> "v_reestr_ord_k1",
  owner=0x110070079 <systables+129> "systec", outfile=0x9001000a0004d40 <_iob+88>,
    outfileG=0x9001000a0004d40 <_iob+88>, tabauths=1, colauths=1, grantas=1) at print_views.ec:253
#2  0x000000010000db8c in main (argc=5, argv=0xffffffffffff308) at myschema.ec:3539
(gdb) print delp
$1 = 0x20000001100b3280 <error: Cannot access memory at address 0x20000001100b3280>

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Thu December 14, 2023 01:12 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Dennis:

Would it be possible to compile it with -g and run it in a debugger to at least get me a location in the code where it is crapping out?

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Thu December 14, 2023 09:41 AM
From: Dennis Melnikov
Subject: Updated utils2_ak package available

Art,

On AIX 7.1, myschema fails with coredump on VIEWs:

Writing full schema DDL to:       stdout
Memory fault(coredump)

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Fri November 24, 2023 01:07 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

That's great. Thanks Dennis. Hopefully that will be enough for me to figure out what's happening.

Art

Starting program: /home/denis/ArtKagel/utils2_ak/myschema -d eagle -t v_reestr_ord_k1
Writing full schema DDL to:       stdout

Program received signal SIGSEGV, Segmentation fault.
0x00000001001c5c84 in gettok2 () at tokens.c:135
135                 *delp = *pos;
(gdb) bt
#0  0x00000001001c5c84 in gettok2 () at tokens.c:135
#1  0x00000001001c3cd4 in print_views (tabid=2904, tabname=0x11006fff8 <systables> "v_reestr_ord_k1",
  owner=0x110070079 <systables+129> "systec", outfile=0x9001000a0004d40 <_iob+88>,
    outfileG=0x9001000a0004d40 <_iob+88>, tabauths=1, colauths=1, grantas=1) at print_views.ec:253
#2  0x000000010000db8c in main (argc=5, argv=0xffffffffffff308) at myschema.ec:3539
(gdb) print delp
$1 = 0x20000001100b3280 <error: Cannot access memory at address 0x20000001100b3280>

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Thu December 14, 2023 01:12 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Dennis:

Would it be possible to compile it with -g and run it in a debugger to at least get me a location in the code where it is crapping out?

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Thu December 14, 2023 09:41 AM
From: Dennis Melnikov
Subject: Updated utils2_ak package available

Art,

On AIX 7.1, myschema fails with coredump on VIEWs:

Writing full schema DDL to:       stdout
Memory fault(coredump)

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Fri November 24, 2023 01:07 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Getting closer. Dennis: Please send me the schema for the v_reestr_ord_k1 view from dbschema -ss.

Art

That's great. Thanks Dennis. Hopefully that will be enough for me to figure out what's happening.

Art

Starting program: /home/denis/ArtKagel/utils2_ak/myschema -d eagle -t v_reestr_ord_k1
Writing full schema DDL to:       stdout

Program received signal SIGSEGV, Segmentation fault.
0x00000001001c5c84 in gettok2 () at tokens.c:135
135                 *delp = *pos;
(gdb) bt
#0  0x00000001001c5c84 in gettok2 () at tokens.c:135
#1  0x00000001001c3cd4 in print_views (tabid=2904, tabname=0x11006fff8 <systables> "v_reestr_ord_k1",
  owner=0x110070079 <systables+129> "systec", outfile=0x9001000a0004d40 <_iob+88>,
    outfileG=0x9001000a0004d40 <_iob+88>, tabauths=1, colauths=1, grantas=1) at print_views.ec:253
#2  0x000000010000db8c in main (argc=5, argv=0xffffffffffff308) at myschema.ec:3539
(gdb) print delp
$1 = 0x20000001100b3280 <error: Cannot access memory at address 0x20000001100b3280>

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Thu December 14, 2023 01:12 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Dennis:

Would it be possible to compile it with -g and run it in a debugger to at least get me a location in the code where it is crapping out?

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Thu December 14, 2023 09:41 AM
From: Dennis Melnikov
Subject: Updated utils2_ak package available

Art,

On AIX 7.1, myschema fails with coredump on VIEWs:

Writing full schema DDL to:       stdout
Memory fault(coredump)

------------------------------
Sincerely,
Dennis

Original Message:
Sent: Fri November 24, 2023 01:07 PM
From: Art Kagel
Subject: Updated utils2_ak package available

Folks:

I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.

Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
parameters. Thanks to Davorin Kremenjas for reporting these issues.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------