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
