You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@trafodion.apache.org by Dave Birdsall <da...@esgyn.com> on 2015/11/20 02:47:16 UTC

odb question

Hi,



I’m playing with odb. I have a simple table:



>>showddl t1;



CREATE TABLE TRAFODION.SEABASE.T1

  (

    A                                CHAR(4) CHARACTER SET ISO88591 COLLATE

      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED

  , B                                CHAR(10) CHARACTER SET ISO88591 COLLATE

      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED

  , PRIMARY KEY (A ASC)

  )

;



--- SQL operation complete.



And a simple map file:



[birdsall@dev01 odb]$ more t1.map

A:SEQ:100

B:IRAND:1:1000



And I am trying to use odb to generate 100000 rows in this table. However,
odb doesn’t seem to load anything, and it doesn’t report any errors:



[birdsall@dev01 odb]$ odb64luo -d traf -l
src=nofile:tgt=TRAFODION.SEABASE.T1:map=t1.map:max=100000:rows=500:parallel=4:loadcmd=UP:errmax=10
-u SOMEUSER -p SOMEPASSWORD

odb [2015-11-20 01:45:25]: starting ODBC connection(s)... (1) 1 2 3 4

Connected to Trafodion

[0] odb version 1.1.0 Load statistics:

       [0] Target table: TRAFODION.SEABASE.T1

       [0] Source: nofile

       [0] Pre-loading time: 1.025 s (00:00:01.025)

       [0] Loading time: 0.028 s(00:00:00.028)

       [0] Total records read: 1

       [0] Total records inserted: 0

       [0] Total number of columns: 2

       [0] Total bytes read: 1

       [0] Average input row size: 1.0 B

       [0] ODBC row size: 14 B (data) + 16 B (len ind)

       [0] Rowset size: 500

       [0] Rowset buffer size: 14.65 KiB

       [0] Load throughput (real data): 0.035 KiB/s

       [0] Load throughput (ODBC): 0.000 KiB/s

       [0] Reader Total/Wait Cycles: 0/0

odb [2015-11-20 01:45:26]: exiting. Session Elapsed time 1.062 seconds
(00:00:01.062)

[birdsall@dev01 odb]$



…



>>select count(*) from t1;



(EXPR)

--------------------



                   0



--- 1 row(s) selected.



Any ideas what I might be doing wrong?



Thanks,



Dave

Re: odb question

Posted by Suresh Subbiah <su...@gmail.com>.

Hi Dave,

I have found the map file quite sensitive to syntax. Blank lines at the end
or certain small changes may throw it off and not give an expected error
message.
One option is to simplify to find the problem (as you may have already done)
We could remove the errmax option, try with a max of 10 rows, try on a
table with a single column etc. Sorry for not having anything more specific.

Thanks
Suresh

On Thu, Nov 19, 2015 at 7:47 PM, Dave Birdsall <da...@esgyn.com>
wrote:

> Hi,
>
>
>
> I’m playing with odb. I have a simple table:
>
>
>
> >>showddl t1;
>
>
>
> CREATE TABLE TRAFODION.SEABASE.T1
>
>   (
>
>     A                                CHAR(4) CHARACTER SET ISO88591 COLLATE
>
>       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
>
>   , B                                CHAR(10) CHARACTER SET ISO88591
> COLLATE
>
>       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
>
>   , PRIMARY KEY (A ASC)
>
>   )
>
> ;
>
>
>
> --- SQL operation complete.
>
>
>
> And a simple map file:
>
>
>
> [birdsall@dev01 odb]$ more t1.map
>
> A:SEQ:100
>
> B:IRAND:1:1000
>
>
>
> And I am trying to use odb to generate 100000 rows in this table. However,
> odb doesn’t seem to load anything, and it doesn’t report any errors:
>
>
>
> [birdsall@dev01 odb]$ odb64luo -d traf -l
>
> src=nofile:tgt=TRAFODION.SEABASE.T1:map=t1.map:max=100000:rows=500:parallel=4:loadcmd=UP:errmax=10
> -u SOMEUSER -p SOMEPASSWORD
>
> odb [2015-11-20 01:45:25]: starting ODBC connection(s)... (1) 1 2 3 4
>
> Connected to Trafodion
>
> [0] odb version 1.1.0 Load statistics:
>
>        [0] Target table: TRAFODION.SEABASE.T1
>
>        [0] Source: nofile
>
>        [0] Pre-loading time: 1.025 s (00:00:01.025)
>
>        [0] Loading time: 0.028 s(00:00:00.028)
>
>        [0] Total records read: 1
>
>        [0] Total records inserted: 0
>
>        [0] Total number of columns: 2
>
>        [0] Total bytes read: 1
>
>        [0] Average input row size: 1.0 B
>
>        [0] ODBC row size: 14 B (data) + 16 B (len ind)
>
>        [0] Rowset size: 500
>
>        [0] Rowset buffer size: 14.65 KiB
>
>        [0] Load throughput (real data): 0.035 KiB/s
>
>        [0] Load throughput (ODBC): 0.000 KiB/s
>
>        [0] Reader Total/Wait Cycles: 0/0
>
> odb [2015-11-20 01:45:26]: exiting. Session Elapsed time 1.062 seconds
> (00:00:01.062)
>
> [birdsall@dev01 odb]$
>
>
>
> …
>
>
>
> >>select count(*) from t1;
>
>
>
> (EXPR)
>
> --------------------
>
>
>
>                    0
>
>
>
> --- 1 row(s) selected.
>
>
>
> Any ideas what I might be doing wrong?
>
>
>
> Thanks,
>
>
>
> Dave
>