SQL语句

# 查询手机验证码
 select DYNAMICCODE from TBL_APPLY_TELVALIDATE where CUSTOM_NAME='弘发永'
 order by DYNAMICCODE desc
 fetch first 1 rows only;

# 查询申请是否成功
 select * from TBL_APPLY_MASTER where APPLY_DATE>='2013-12-23' and LAST_STATUS =1
 
# 点击新用户
http://182.180.80.44/creditcardapply/front/apply/index.html

# 选择工作学历或资产checkbox
http://182.180.80.44/creditcardapply/front/apply/new/index.htm

# 输入姓名、省份、城市、证件类型、证件号和验证码
http://182.180.80.44/creditcardapply/front/apply/new/identity.html#nogo
# 输入手机号、邮箱地址、手机验证码
http://182.180.80.44/creditcardapply/front/apply/new/identity.html#nogo

# 输入基本资料、详细资料和联系人信息
http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html
# 输入工作及其他信息
http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html
# 自选服务项目
http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html
# 确认并提交
http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html

# 提交成功
http://182.180.80.44/creditcardapply/front/apply/new/newSubmit.html

查询数据库
tbl_apply_master
tbl_apply_newInfor

添加索引
create index idx_name on table tbl_apply_master( apply_name)

web：182.180.80.86   182.180.80.87
app：182.180.80.44   182.180.80.52
数据库：182.180.80.177

 

 

select * from tbl_apply_master where apply_name = '王一' or apply_name = '网易'
select * from tbl_apply_newinfo where apply_chname = 'WANG YI '
select count(*) from tbl_apply_master
select min（）
select count(*) from tbl_apply_newinfo
delete from tbl_apply_master where apply_name = '王一' or apply_name = '网易'
delete from tbl_apply_newinfo where apply_chname = 'WANG YI '
delete from tbl_apply_master where apply_uuid not in (select apply_uuid from tbl_apply_newinfo )

delete from WCMU.TBL_APPLY_MASTER where apply_uuid in (select * from tbl_apply_master where apply_name = '王一' or apply_name = '网易')
delete from WCMU.TBL_APPLY_MASTER where APPLY_UUID = '437d952c-abfb-485a-8e8f-372886014b79'

delete from tbl_apply_track where apply_uuid in (select apply_uuid from tbl_apply_master where apply_name = '王一' or apply_name = '网易')

20140119：提交姓名和证件号的时候会查询数据库，1000万条基础数据导致查询时占用数据库服务器磁盘100%I/O资源并且查询数据库时间过长，返回超时，无法进行性能测试。

20140120：在100万条基础数据下可以正常进行性能测试，目前进行了三要素页面的80人负载和50强并发场景的性能测试，TPS和响应时间均可以达到测试指标。

20140121：目前还在优化性能测试环境的数据库索引，同时在插入基础数据，无法进行性能测试。

（一）标题：新客户流程稳定性测试过程中出现504 Gateway Time-out 错误

内容：如下页面出现这个问题：

1、Action.c(12): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/index.html"
2、Action.c(103): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/new/identity.html"
3、Action.c(150): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/common/productVal.json"
4、Action.c(178): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/identityVerify.html"
5、Action.c(283): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html"
6、Action.c(424): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/new/workInfo.html"
7、Action.c(535): Error -26608: HTTP Status-Code=504 (Gateway Time-out) for "http://182.180.80.44/creditcardapply/front/apply/new/optionalService.html"

（二）标题：新客户流程稳定性测试过程中出现Step download timeout错误
内容：如下页面出现这个问题：
1、http://182.180.80.44/creditcardapply/front/apply/new/identity.html
2、http://182.180.80.44/creditcardapply/front/apply/new/personalInfo.html

 

delete from (select * from tbl_apply_master where apply_tel like '133%' fetch first 5000 rows only)

nmon -F identity100in177.nmon -t -s5 -c132

 

 

修改系统时间 date -s MM/DD/YYYY
进入数据库 su - 用户名 如：su - wcmu
reorgchk

快照数据就是比较乱,你可以尝试一下快照函数,这样数据就好看多了.
SELECT * FROM TABLE( SNAPSHOT_DYN_SQL( 'SAMPLE', -1 )) as SNAPSHOT_DYN_SQL
不过要记得打开监控开关哦!
update monitor switches using <monitor>; <on|off>;   为 <monitor>;设置会话监控开关的状态。
比如：
update monitor switches using bufferpool on lock on sort on statement on table on uow on

SQL语句
select channel,count(channel) from tbl_ec_ojnl group by channel

 

 

 

select * from tbl_ec_usr where user_id = '7048798'
select * from tbl_ec_usr where mobile = '1335100189'
select * from tbl_ec_ucrd where user_id = '7011000'
select * from tbl_ec_ucrd where card_no = '6226560727947879'
update tbl_ec_usr set password = 'd6dbb24a3ba7873e' where user_id = '7047592'
select * from tbl_sv_dymc where verify_credential_id = '13351000212'
select * from tbl_sv_dymc where verify_dynamic_code_seq = '35'
select * from tbl_ec_uect where user_id = '7011000'
select * from tbl_ec_uect where contact_addr =  '383343281'
update tbl_ec_uect set verified = '0' where  user_id = '7011004' and contact_type = 'QQ'
update tbl_ec_uect set contact_addr = '' where user_id = '7011004' and contact_type = 'QQ'
update tbl_ec_ucrd set card_no = '5218990187877971'  where user_id = '7048732'
select * from tbl_ec_ojnl where trans_date = '2028-09-12' and terminal_type = 'MOBLIE' and client_ip = '140.206.255.228'
select * from tbl_ec_ojnl where trans_date = '2014-07-25' and terminal_type = 'MOBLIE' and user_id = '7011003'
update tbl_ec_usr set cert_verified = '0' where user_id = '7047485'

select channel,count(channel) from tbl_ec_ojnl group by channel

select mobile from tbl_ec_usr where length(mobile) = 11

 

select * from tbl_ec_uect where user_id = '7047483'
select * from tbl_ec_uect where contact_addr = '1955477826'
select * from tbl_ec_uect where contact_name = '测试（easy）'
select * from tbl_ec_uect where contact_addr = '383343281'
select * from tbl_ec_uect where contact_name = '常想一二'
select * from tbl_ec_uect where contact_addr = '472991701'
select * from tbl_ec_uect where contact_name = 'Karry'
select * from tbl_ec_uect where contact_type = 'QQ' and contact_addr != ''
select * from tbl_ec_uect where contact_name like '义%'

delete from tbl_ec_uect where user_id = '7011000'

select * from tbl_ec_uect order by user_id desc

update tbl_ec_uect set user_id = '7011000' where  contact_addr = 'o_WQPuK21Dt1hzOYVhu3FhsEg6fY';
update tbl_ec_uect set user_id = '7047483' where  contact_addr = '383343281';

update tbl_ec_uect set user_id = '7011234' where  contact_addr = 'o_WQPuA1x3YOB-bQiw5nICUnkcY4' ;
update tbl_ec_uect set user_id = '7047481' where  contact_addr = '1666180578';

update tbl_ec_uect set user_id = '7047479' where  contact_addr = 'o_WQPuMOL6xKsFIoiVDscMUXqwDM';
update tbl_ec_uect set user_id = '7047479' where  contact_addr = '472991701'

update tableA set tableA.columnA1 = tableB1.columnB from tableB where tableA.columnA2 = table.columnB2